Solved

DTS package fails to run when scheduled

Posted on 2004-08-31
5
570 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

744 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

13 Experts available now in Live!

Get 1:1 Help Now