DTS

Hi folks,
I am running an Active-X in DTS package and it works perfect when execute
from the DTS design area but it fails when run as JOB. This is the error i
get. Any idea? I couldnt figure out the clue from this error msg. Any help
appreciated. TIA
************************************************** *********
Executed as user: ABC\SYSTEM. DTSRun: Loading... DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnError:
DTSStep_DTSActiveScriptTask_1, Error = -2147220421 (8004043B) Error
string: The task reported failure on execution. Error source:
Microsoft Data Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 1100 Error Detail Records: Error:
-2147220421 (8004043B); Provider Error: 0 (0) Error string: The task
reported failure on execution. Error source: Microsoft Data
Transformation Services (DTS) Package Help file: sqldts80.hlp Help
context: 1100 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun:
Package execution complete. Process Exit Code 1. The step failed.
************************************************** ***********
Either because it's now runnnig as user ABC\SYSTEM rather than as your login
or because all paths are now relative to the server (and using different
mapped drives) instead of relative to your workstation.
Those are the usual problems when executing on the server.
"rupart" wrote:

> Hi folks,
> I am running an Active-X in DTS package and it works perfect when execute
> from the DTS design area but it fails when run as JOB. This is the error i
> get. Any idea? I couldnt figure out the clue from this error msg. Any help
> appreciated. TIA
> ************************************************** *********
> Executed as user: ABC\SYSTEM. DTSRun: Loading... DTSRun: Executing...
> DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnError:
> DTSStep_DTSActiveScriptTask_1, Error = -2147220421 (8004043B) Error
> string: The task reported failure on execution. Error source:
> Microsoft Data Transformation Services (DTS) Package Help file:
> sqldts80.hlp Help context: 1100 Error Detail Records: Error:
> -2147220421 (8004043B); Provider Error: 0 (0) Error string: The task
> reported failure on execution. Error source: Microsoft Data
> Transformation Services (DTS) Package Help file: sqldts80.hlp Help
> context: 1100 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun:
> Package execution complete. Process Exit Code 1. The step failed.
> ************************************************** ***********