November 9, 2003 at 2:33 pm
G'Day,
A DTS job of mine failed this morning and Sunday.
Unfortunately it failed after running for over an hour so it is impraticle to run it interactively (and it brings the server to its knees) to find out what is wrong with it. The job history is next to useless.
Executed as user: HAHS\SQLServer. ...nStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_22 DTSRun OnProgress: DTSStep_DTSDataPumpTask_22; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_22; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_22; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_22; 3611 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3611 DTSRun OnFinish: DTSStep_DTSDataPumpTask_22 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1000 Rows have been transfo... Process Exit Code 1. The step failed.
Is there a method to help determine the cause?
In this instance, it is probably due to a datapump task I added on Saturday. It is named DTSStep_DTSDataPumpTask_25 but does not appear in the list.
Thanks,
November 9, 2003 at 2:44 pm
Hi,
Reposted in the DTS forum, where it is more appropriate.
Please look there for more info.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply