DTS error

i've a problems on this ...

Please help ..

Executed as user: MBADOMAIN\Administrator. ...
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: DTSStep_DTSActiveScriptTask_2
DTSRun OnError: DTSStep_DTSActiveScriptTask_2,
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
DTSRun: Package execution .
The step failed.Hi!

Did you try to execute "DTSStep_DTSActiveScriptTask_2" alone in the Enterprise Manager? It should be an error in this script.

Carsten|||Originally posted by CarstenK
Hi!

Did you try to execute "DTSStep_DTSActiveScriptTask_2" alone in the Enterprise Manager? It should be an error in this script.

Carsten

hi,

yes, i did it ! my situation is the DTS package is runs error-free from the Enterprise Manager, but the DTS package fails when it is scheduled to run as a job.

wersa