Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

SQL Server DTS Error

Options
  • 09-08-2005 3:51pm
    #1
    Kai
    Registered Users Posts: 604 ✭✭✭


    Howdy,

    Ive created a dts job which runs perfectly in the EM but when i try to use DTSRUN it gives me back this unhelpful crap :
    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
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:  sqldts.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:  sqldts.hlp

   Help context:  1100



DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_1

DTSRun:  Package execution complete.


(19 row(s) affected)

    *sigh
    anyone have any ideas as to what it might be. No errors in EM at all. and im running it with sa permissions at the moment.


Comments

Advertisement