Execute Process Task catch return code

#1

Hello:

I have a DTS package and it will call a .exe file in Execute Process
Task. I need to catch the return code from the .exe after it executs.
However, the Return Code in Execute Process Task is what the DTS step
will return if it's successful. So how can I catch any retrun code from
..exe?

Thanks for any help!

#2

xyc,

Find examples of ERRORLEVEL command usage. Execute your .exe in a batch
file and write ERRORLEVEL into a text file or to an environmental variable.

Ilya

"xyc" <xiyingchun (AT) hotmail (DOT) com> wrote

Quote:

Hello:

I have a DTS package and it will call a .exe file in Execute Process
Task. I need to catch the return code from the .exe after it executs.
However, the Return Code in Execute Process Task is what the DTS step
will return if it's successful. So how can I catch any retrun code from
.exe?

Thanks for any help!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Execute Process Task catch return code

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Execute Process Task catch return code - 02-14-2005 , 12:50 PM

Re: Execute Process Task catch return code - 02-16-2005 , 10:38 AM