Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jubilanttiger
Starting Member
19 Posts |
 Posted - 2005-05-23 : 11:14:12
|
| Hi,I have a DTS job running and it failed to run yesterday nite.This is the data which I am getting from the Job History:Executed as user: ********************SStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSDataPumpTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: DTSStep_DTSDataPumpTask_4 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; Progress... Process Exit Code 1. The step failed.My Question is, can you tell me which Step and which Task Failed from the DTS Job. Actually the DTS job has a lot of tasks in it. I am able to trace which task failed from the above job history.Thanks a lot for your time....... |
|
|
jubilanttiger
Starting Member
19 Posts |
Posted - 2005-05-23 : 11:18:50
|
| The following is the Job History (Made Easier to Read)Executed as user: *******************. ...SStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSDataPumpTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: DTSStep_DTSDataPumpTask_4 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; Progress... Process Exit Code 1. The step failed. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-05-23 : 22:14:29
|
step 4, indicative that you should check:1. network problems during transfer2. amount of data being transferred3. log size if getting filled up (try to unrestrict the growth and re-run the job)4. blocks occuring, check the sequence for the dts stepsthere is not enough information for us to help you, but you can try to work on the above items and see if that'll help you...  --------------------keeping it simple... |
|
|
|
berengar
Starting Member
21 Posts |
Posted - 2008-10-01 : 05:57:05
|
| I know very late reply here .. but to get more information with DTS packages if you do a Disconnected edit you can see exactly which tasks/Stored Procedures are associated with DataPumptasks... |
|
|
|
|
|
|
DTS Job Failure Process Exit Code 1