Results 1 to 3 of 3

Thread: DTS error

  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unhappy Unanswered: 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.

  2. #2
    Join Date
    Sep 2003
    Location
    Germany
    Posts
    63
    Hi!

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

    Carsten

  3. #3
    Join Date
    Oct 2003
    Posts
    2
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •