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