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

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Maxwell,

"Maxwell" wrote: 
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

you mean no error was logged, didn't you? Please take a precise look at the logfile.
There can be a strange behaviour, tellling you, that the package was executed successfully at the beginning of the log, but in the step execution list, there is an entry starting with "error on step ..." where the step was never executed.
If this is the case, dtsrun will always return 1 as errorlevel, although the package was mainly executed successfull.

If you haven't this scenario, I'm sorry, I haven't seen such behaviour before and have no further ideas in the moment.

Helge 

.

Quantcast