I have a SQL Agent Job in SQL Server 2000 that uses a DTS Package to import information from an ORACLE source. This is a direct import with no special transformations. I have this job scheduled to run every day however after 3 days of flawless execution, I began to have failures being reported from the execution of the job. Inside the SQL Server Agent 'Job History' window for this job the following is displayed:
"Executed as user: <defineduser>. ...OnStart: DTSStep_DTSExecuteSQLTask_
1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_
1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_3 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnStart: DTSStep_DTSDataPumpTask_4 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1;
1 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun OnProgress: DTSStep_DTSDataPumpTask_4;
1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_4;
2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_4;
3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_4;
4000 Rows have been transformed or copied.; Perc... Process Exit Code 2. The step failed."
I'm not sure why I am receiving this error; I have plenty of space on the drive so space shouldn't be an issue. Unfortunately my import is imcomplete because the package/job won't complete. Any ideas?
Start Free Trial
