April 11, 2003 at 9:14 am
My DTS package includes a script to rename a file. When I schedule the package in SQLAgent it fails with the error:
DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error string: ActiveX Scripting encountered a Run Time Error during the execution of the script. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 Error Detail Records: Error: -2147220482 (800403FE); Provider Error: 0 (0)
I looked up Microsoft's refrence to this error and it said to add the user to the DCOM security setting. I did this but still get the same error. Even tried rebooting the server to no avail. The package runs fine when directly executing it from the DTS view in Enterprise Manager. It only fails in SQLAgent! HELP!!
April 11, 2003 at 10:50 am
Check that the user account you use to start the agent has permissions into the files.
April 11, 2003 at 11:06 am
Well, now I feel dumb. The problem was close to what you suggested. The files had permissions to everyone but the user that was running the SQLAGENT service did not have logon access to the other server. Thanks for the pointer!!!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply