Solved

DTS package fails to run when scheduled

Posted on 2004-08-31
5
572 Views
Last Modified: 2013-11-30
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.
0
Comment
Question by:janderson131
5 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 125 total points
ID: 11944921
>>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
 

Author Comment

by:janderson131
ID: 11945603
thanks. I will give this a try...
0
 
LVL 34

Expert Comment

by:arbert
ID: 11946336
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

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now