October 17, 2002 at 1:43 am
I run a DTS package with a Scheduled Job and get the following error:
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE)
Error string: Error Code: 0 Error Source= Microsoft VBScript runtime error
Error Description: Object required: 'WshShell' Error on Line 19
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) Error string: Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Object required: 'WshShell'
Error on Line 19
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4500
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
DTSRun: Package execution complete. Process Exit Code 1. The step failed.
If I run the package from the enterprise manager manualy the package runs without error. Any idea?
October 17, 2002 at 2:51 am
Check the permissions for the account that SQL Server Agent is running under. My guess is that your script is running fine under your account when you run it from EM because you have proper permissions. It sounds like SQL Server Agent does not have proper authority to access the WshShell object...
hth,
Michael
Michael Weiss
Michael Weiss
October 17, 2002 at 9:16 am
The job is running with the same account as the SQL Server Agent service is started.
Any other idea ?
kind regards heike
I changed the script used in the job and now it works. thanks !
kind regards heike
Edited by - heiket on 10/18/2002 07:21:22 AM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply