DTS package fails to run when scheduled

DTS step 1 runs. Step 2: both DTS and stored runs OK directly, but fail as a scheduled job. Below is the text from the job history details.

Thanks in advance!!!

 DTSRun:  Executing...   DTSRun OnStart:  Create Table Results Step   DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnFinish:  Create Table Results Step   DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnStart:  Copy Data from Results to Results Step   DTSRun OnStart:  DTSStep_DTSDataPumpTask_1   DTSRun OnError:  DTSStep_DTSDataPumpTask_1, Error = -2146959361 (8007FFFF)      Error string:  Catastrophic failure         Error source:  Microsoft Data Transformation Services (DTS) Package      Help file:  sqldts80.hlp      Help context:  4700      Error Detail Records:      Error:  -2146959361 (8007FFFF); Provider Error:  0 (0)      Error string:  Catastrophic failure         Error source:  Microsoft Data Transformation Services (DTS) Package      Help file:  sqldts80.hlp      Help context:  4700         Error:  -2146959361 (8007FFFF); Provider Error:  0 (0)      Error string:  Catastrophic failure         Error source:  Microsoft Data Transformatio...  Process Exit Code 2.  The step failed.
janderson131Asked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
>>DTS step 1 runs. Step 2: both DTS and stored runs OK directly, but fail as a scheduled job<<
That is because the scheduled job is running on the server and may not have access/permission to the file(s) required.
0
 
janderson131Author Commented:
thanks. I will give this a try...
0
 
arbertCommented:
agree with acperkins--it will run in the context of the SQLAgent account....

"Error string:  Catastrophic failure  "


gotta love microsoft--such dramatic error messages lol
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.