Sunday, March 11, 2012

Aysnchronously calling a package

Hello,

Is there a way to call SSIS package within another SSIS package, asynchronously. Any pointers would be much appreciated.

Thanks

Vishal

Say if you control flow looks like:

step 1
|
|
|_
| |
| |
step 2 step 3
|
|
step 4
And say step 3 is execute package task that you want to run asynchronously.
Can you describe your issues with this? Are you looking for event handlers?

Nitesh

|||

[Including Michael's answer for posterity]

You can use Execute Process task to run the package using DTEXEC.EXE utility.

To run DTEXEC without execute process task waiting for it, either specify a small timeout and set TerminateProcessAfterTimeOut to false, or start the DTEXEC using ‘cmd /c start dtexec.exe /F filename’ command.

No comments:

Post a Comment