May 26, 2011 at 5:52 am
I have several dts on my sql2005 server with activex tasks that open one excel file and then put some data from database table to file and since yesterday dts don't work with errors
Error Description: Unknown runtime error: 'appExcel.Workbooks.open'
DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE)
I tried to create job with activex vbs task but error is the same while when i put script to file on that same server and run it like .vbs it works just fine. We tried to reinstall excel but nothing changed.
This same dts and jobs work just fine on another server
May 26, 2011 at 11:21 am
Sounds like the SQLAgent Account does not have permissions to open the Excel file.
Check permissions.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 27, 2011 at 1:53 am
i checked that first but account that runs task is local admin on server
May 27, 2011 at 7:08 am
irena.bulatovic (5/27/2011)
i checked that first but account that runs task is local admin on server
My guess is that the file(s) that it is trying to open are on another machine?
Local Admin does not have permissions to anything that is not located on that Server.
You need to use an Account that has privileges access to the resources that it needs.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 30, 2011 at 1:39 am
File was on the same machine as sql server and if I put scrip into vbs file on the server it works fine but from job on the same server it didn't work at all. I moved resources from one node to another and restarted server and that solved problem. I didn't tried that earlier because this is our production server so it has to be up 24/7.Thanks anyway
June 1, 2011 at 8:41 am
irena.bulatovic (5/30/2011)
File was on the same machine as sql server and if I put scrip into vbs file on the server it works fine but from job on the same server it didn't work at all. I moved resources from one node to another and restarted server and that solved problem. I didn't tried that earlier because this is our production server so it has to be up 24/7.Thanks anyway
It sounds as if the package is trying to access a resource someone on another server.
What does the package do?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply