When executing the regional DTS via a SQL job, the job
fails. There is the error code:
Executed as user: AMED\xxx.xxxxxx. ...art:
DTSStep_DTSDataPumpTask_33 DTSRun
OnProgress: DTSStep_DTSDataPumpTask_33; 375
Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 375 DTSRun
OnFinish: DTSStep_DTSDataPumpTask_33 DTSRun
OnStart: DTSStep_DTSDataPumpTask_1 DTSRun
OnStart: DTSStep_DTSDataPumpTask_34 DTSRun
OnProgress: DTSStep_DTSDataPumpTask_34; 55
Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 55 DTSRun
OnFinish: DTSStep_DTSDataPumpTask_34 DTSRun
OnProgress: DTSStep_DTSDataPumpTask_1; 73
Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 73 DTSRun
OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun
OnStart: DTSStep_DTSDataPumpTask_7 DTSRun
OnStart: DTSStep_DTSDataPumpTask_2 DTSRun
OnStart: DTSStep_DTSDataPumpTask_3 DTSRun
OnStart: DTSStep_DTSDataPumpTask_22 DTSRun
OnProgress: DTSStep_DTSDataPumpTask_22; 8
Rows have been transformed or copied.; Percen...
Process Exit Code 1. The step failed.