janderson131
asked on
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.
Thanks in advance!!!
DTSRun: Executing... DTSRun OnStart: Create Table Results Step DTSRun OnStart: DTSStep_DTSExecuteSQLTask_
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
"Error string: Catastrophic failure "
gotta love microsoft--such dramatic error messages lol
ASKER