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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

SQL Server DTS Error

  • 09-08-2005 2:51pm
    #1
    Kai
    Registered Users, Registered Users 2 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