We help IT Professionals succeed at work.
Get Started

SQL Server 2000 SQL Agent Job Error

irishm20
irishm20 asked
on
819 Views
Last Modified: 2013-11-30
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?
Comment
Watch Question
Top Expert 2007
Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE