DTS package remotely

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!

.

Relevant Pages

  • Re: AS2005 x64 vs x86 performance
    ... When you run Profiler against the server do you see any other activity? ... Each execution made one execution unit 100%. ... As soon as the XMLA was executed the queries get answered. ... The disk sys on the xeon srv is a FC SAN where I have an array of 4 FC ...
    (microsoft.public.sqlserver.olap)
  • Re: Replies to e-mails not received
    ... 07:17:14 Successfully initialized the resource manager ... Retrieving Blob ... server ready.") ...
    (microsoft.public.outlook)
  • Re: AS2005 x64 vs x86 performance
    ... cached data on the 64-bit server is much larger and it the commit operation ... My issues are related with XMLA ... executed one of the execution units goes 100% for some seconds. ... The disk sys on the xeon srv is a FC SAN where I have an array of 4 FC ...
    (microsoft.public.sqlserver.olap)
  • Asp.Net.Vulnerability: Full Trust (current security problems and possible solutions)
    ... As Long) As Long") is to reduce the website's trust level from 'Full ... of use and rapid development features of Access and SQL server ... execution, disclosure of usernames and system information, etc... ... Have one website per virtual server ...
    (microsoft.public.security)
  • Asp.Net.Vulnerability: Full Trust (current security problems and possible solutions)
    ... As Long) As Long") is to reduce the website's trust level from 'Full ... of use and rapid development features of Access and SQL server ... execution, disclosure of usernames and system information, etc... ... Have one website per virtual server ...
    (microsoft.public.inetserver.iis.security)