I am new to both Tek-tips and SQL Server. I have used the Export wizard in SQL Server 7.0 to generate a DTS Package which exports some data to a static Excel Spreadsheet. I can execute this package from within enterprise manager. I have written a VBScript to run the package from a web page. When I run the Page, the package executes as follows:
Step 1 Delete the table from the excel spreadsheet.
Step 2 Re-Create the table in the excel spreadsheet.
Step 3 Export a SQL Query result to the table in the spreadsheet.
The first two steps execute, but the final step fails. I thought this might be a permission problem, but I don't understand why the first two steps would execute if it was a permission problem. My second thought was Read/Write permissions on the webserver for the folder. I changed the folder on the webserver (and checked the file permissions as well) to allow Read/Write capabilities. Nothing has helped.
Any information or links that could lead to solving this problem would be greatly appreciated.
Step 1 Delete the table from the excel spreadsheet.
Step 2 Re-Create the table in the excel spreadsheet.
Step 3 Export a SQL Query result to the table in the spreadsheet.
The first two steps execute, but the final step fails. I thought this might be a permission problem, but I don't understand why the first two steps would execute if it was a permission problem. My second thought was Read/Write permissions on the webserver for the folder. I changed the folder on the webserver (and checked the file permissions as well) to allow Read/Write capabilities. Nothing has helped.
Any information or links that could lead to solving this problem would be greatly appreciated.