Re: The DTSRun statement runs without error, yet returns ErrorLeve

I reran the batch file after editing the DTS package to log execution to
SQLServer and to write errors out to a text file. Nothing was logged to the
text file and the
sysdtssteplog table didnt have any records with errorcode <> 0. I obtained
the same results - DTS package apparently succeeded, but ErrorLevel 1 was
returned.

"Helge C. Rutz" wrote:

> Hi Maxwell,
>
> "Maxwell" wrote:
> >I am executing a DTSRun statement from a batch file running on Windows XP
> and
> > am checking for ErrorLevel 1 in order to perform error handling tasks.
> > The DTSRun statement runs without error, yet returns ErrorLevel 1.
> ....
> > **********************************************
> > Results of Executing DTSRun statement
> > DTSRun OnProgress: DTSStep_DTSDataPumpTask_2; 156 Rows have been
> > transformed or copied.; PercentComplete = 0; ProgressCount = 156
> > DTSRun OnFinish: DTSStep_DTSDataPumpTask_2
> > DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2
> > DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2
> > DTSRun: Package execution complete.
> > *******************************
> > --DTSLOAD: ERROR --
>
> How do you know that the dts package runs without errors?
> Please enable the logging of the dts package and see the detailed logfile
> for informations of failed steps.
> I know one scenario where the manipulation of the workflow of the package
> by explicitly setting the execution status of steps can lead to this
> behaviour.
>
> Helge
>
>
.

Relevant Pages

  • Re: How to capture SQL statement messages in DTS log file
    ... I have several SQL Server 2000s and a couple of SQL Server 2005 servers ... Then instead of PRINT in your DTS package, ... The execution of the following DTS Package succeeded: ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.dts)
  • Re: How to capture SQL statement messages in DTS log file
    ... Then instead of PRINT in your DTS package, ... The execution of the following DTS Package succeeded: ... -- Return 0 to the calling program to indicate success. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.dts)
  • Re: How to capture SQL statement messages in DTS log file
    ... is a DTS package that is run through the job scheduler. ... The execution of the following DTS Package succeeded: ... Update statistics for DYNAMICS User Tables ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.dts)
  • Re: Batch file and MFC (Properly Terminating Application)
    ... This is continuation of previous post listed under Subject: Batch file ... EVER write something as ridiculous as comparing a BOOL to TRUE or FALSE!!!! ... execution, and therefore presuming synchronous execution is completely wrong. ... TraceEvent * Explanation ...
    (microsoft.public.vc.mfc)
  • Re: Problem when executing application from batch file
    ... I like that /b extra parameter as indication of the batch execution too. ... It will allow me to provide special code for batch file execution only, ... >>from command prompt and if there are more commands it will store commands ... > until the /Windows/ App is closed ...
    (microsoft.public.vb.general.discussion)