DTS and process task - doesn't wait my called exe application finish completely -- sql server dts

teixeira1985 NO[at]SPAM gmail.com
5/22/2007 8:50:28 AM

Hi,

I need to execute a DTS that have a couple of steps and one of them is
a process task that simply call an exe file i made that will send an
email to warn the user.

What happens here is that the process task executes my exe file but it
doesn't wait for it to compete and fires the next task after and
finally closes.

There is anyway to make a "while statament" to wait until my exe
application finishes?

Any idea?

Thanks in advance,
Tiago Teixeira

Francisco A. Gonzalez
5/22/2007 6:17:03 PM

In SSIS,
it waits for it to complete if the have a preceden upon completition, this
is the default way to link tasks.

cheers

--

Francisco A. Gonzalez
fgonzalez@solidq.com

[quoted text, click to view]

sql server dts : DTS and process task - doesn't wait my called exe application finish completely