"tiv" <jmattivi@gmail.com> wrote in message
news:1168987036.038056.85330@38g2000cwa.googlegroups.com:

> I'm executing a dts package on a remote server from a local machine
> with the dtsrun cmd. I have all the same ODBC connections on the local
> computer that the server has, registered the appropriate .dlls on the
> local box. The batch file is getting to the package and kicking it
> off. For some reason, all the "dtsstep_datapumptask" are not
> executing.
>
> Failed Log file:
>
> Step 'DTSStep_DTSDataPumpTask_8' was not executed
>
> Step 'DTSStep_DTSDataPumpTask_19' was not executed
>
> Step 'DTSStep_DTSDataPumpTask_20' was not executed
>
> Step 'DTSStep_DTSDataPumpTask_21' was not executed
>
> Step 'DTSStep_DTSDataPumpTask_22' was not executed
>
> Successful Log file:
>
> Step 'DTSStep_DTSDataPumpTask_8' succeeded
> Step Execution Started: 1/15/2007 3:36:32 PM
> Step Execution Completed: 1/15/2007 3:42:52 PM
> Total Step Execution Time: 379.765 seconds
> Progress count in Step: 150797
>
> Step 'DTSStep_DTSDataPumpTask_19' succeeded
> Step Execution Started: 1/15/2007 3:42:56 PM
> Step Execution Completed: 1/15/2007 3:42:59 PM
> Total Step Execution Time: 3.672 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSDataPumpTask_20' succeeded
> Step Execution Started: 1/15/2007 3:42:59 PM
> Step Execution Completed: 1/15/2007 3:43:01 PM
> Total Step Execution Time: 1.203 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSDataPumpTask_21' was not executed
>
> Step 'DTSStep_DTSDataPumpTask_22' succeeded
> Step Execution Started: 1/15/2007 3:36:32 PM
> Step Execution Completed: 1/15/2007 3:42:56 PM
> Total Step Execution Time: 383.359 seconds
> Progress count in Step: 41
>
> **Note: Some tasks do fail in the successful run (performed on the
> server)
>
> Thanks in advance for your help!