Querying DTS Tables For Log Information
- 2
- Add a Comment
Today I was looking the SQL Server Agent jobs on one of my SQL Server 2000 production database servers. I noticed one job that failed with a very cryptic error. This was the error message reported:
DTSRun OnStart: DTSStep_DTSDataPumpTask_6 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_6; 1000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_6; 2000 [...]