Re: DTS package remotely

So the tasks that fail where are they in the log?? How do they relate to the Datapump tasks? What are the errors?

--


Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com




"tiv" <jmattivi@xxxxxxxxx> wrote in message news:1168987036.038056.85330@xxxxxxxxxxxxxxxxxxxxxxxxxxx:

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

  • Cannot open a log file of specified name
    ... I have a DTS package called 'MASTER' which performs 8 execute DTS package ... The execution of the following DTS Package succeeded: ... Total Step Execution Time: 2.375 seconds ... Progress count in Step: 0 ...
    (microsoft.public.sqlserver.dts)
  • Re: Catastrophic failure
    ... Package Name: UNIFUND ... Package Execution Lineage: ... Total Step Execution Time: 1.061 seconds ... Progress count in Step: 0 ...
    (microsoft.public.sqlserver.dts)
  • Re: Response.Write Question
    ... There is no official hook letting you know the progress ... What could be done in some cases (with action queries rather than SELECT ... code does not work asynchronously with the query execution thread). ... likely to make the whole execution time larger, ...
    (microsoft.public.access.queries)
  • Re: Catastrophic failure
    ... Funky source or destination? ... Allan Mitchell MCSE,MCDBA, www.SQLDTS.com - The site for all your DTS needs. ... > Total Step Execution Time: 1.802 seconds> Progress count in Step: 0 ...
    (microsoft.public.sqlserver.dts)
  • Re: COBOLs Influence on C
    ... Robert's reply seems to "assume" an IBM mainframe environment. ... learn of missing external names either at link or execution time. ... compilation and before execution. ...
    (comp.lang.cobol)