I have a scheduled DTS job that runs once a week. It's been running with no errors except for one time several weeks ago. The step which is failing is performing a select on an Oracle table and outputing the results to a file on the server.
Error messages generated were:
Executed as user: MBG\SQLService.
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
DTSRun OnStart: DTSStep_DTSDataPumpTask_2
DTSRun OnError: DTSStep_DTSDataPumpTask_2,
Error = -2147467259 (80004005)
Error string:
Error source:
Help file:
Help context: 0
Error Detail Records:
DTSRun OnFinish:
DTSStep_DTSDataPumpTask_2
DTSRun: Package execution complete.
Process Exit Code 1.
The step failed.
Not very illuminating. Any ideas?
Error messages generated were:
Executed as user: MBG\SQLService.
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
DTSRun OnStart: DTSStep_DTSDataPumpTask_2
DTSRun OnError: DTSStep_DTSDataPumpTask_2,
Error = -2147467259 (80004005)
Error string:
Error source:
Help file:
Help context: 0
Error Detail Records:
DTSRun OnFinish:
DTSStep_DTSDataPumpTask_2
DTSRun: Package execution complete.
Process Exit Code 1.
The step failed.
Not very illuminating. Any ideas?