May 29, 2007 at 12:14 pm
Hi All,
we have scheduled a job to run each day. It failed a week back and the job history shows error.
Job Name new_order
Duration 00:03:23
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: calfon\ServicebuildSQL. ...SStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_4 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnStart: DTSStep_DTSDataPumpTask_3 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 5000 ... Process Exit Code 1. The step failed.
Unable to restart the job. What does process Exit Code 1 means.
Thanks in advance
May 29, 2007 at 2:18 pm
This is just a generic exception thrown by SSSIS. Your best bet is to debug the package from VS/BID - I would recommend adding a data viewer in on the transform so you can view the offending row(s). You may even want to add in some event handlers which will provide you with a bit more detail.
Tommy
Follow @sqlscribeMay 29, 2007 at 3:49 pm
Something happened at this step:
DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.;
It transformed or copied the first 5000 records and then failed. Something may have been wrong with the next 1000 rows.
Run the package manually and see what happens.
-SQLBill
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply