Hi
I have written some code to execute a DTS package in SQL server. Part of the process is to use an Excel spreadsheet as a connection/datasource, empty it and load in some data. I know this process works fine so will not dwell on it too much.
If I execute the package through Enterprise Manager it runs fine. When I execute through ASP.NET I get an error as described in the subject (Failure creating file). It's an ExecuteTask object in the package that does a drop and create on the spredsheet.
My initial hunch was that the user I was impersonating did not have rights to the folder where the xls is saved - so I added it with full control - no joy
I ran a SQL Profiler to confirm that the package is being executed by the user that I thought it was being executed by - and it was.
Does anybody have any idea?
Cheers
Rob
ps. I have posted in ASP.NET topic as well, in case this is not the best topic to have posted in for this issue
I have written some code to execute a DTS package in SQL server. Part of the process is to use an Excel spreadsheet as a connection/datasource, empty it and load in some data. I know this process works fine so will not dwell on it too much.
If I execute the package through Enterprise Manager it runs fine. When I execute through ASP.NET I get an error as described in the subject (Failure creating file). It's an ExecuteTask object in the package that does a drop and create on the spredsheet.
My initial hunch was that the user I was impersonating did not have rights to the folder where the xls is saved - so I added it with full control - no joy
I ran a SQL Profiler to confirm that the package is being executed by the user that I thought it was being executed by - and it was.Does anybody have any idea?
Cheers
Rob
ps. I have posted in ASP.NET topic as well, in case this is not the best topic to have posted in for this issue
