We currently execute an SSIS package via Execute External SSIS Package. We want to start using SSIS environments to better manage dev/prod values and passwords. The problem with the Execute External SSIS Package is that we are not able to call the SSIS package using an SSIS Environment. To get around this, we created a Script Action that executes the SSIS package with an SSIS Environment, and then set this script action as a Post Script on a table that is executed in our Execution Package. The problem I am facing is that calling the SSIS package in this manor calls it asynchronously. Is there a way to synchronously call an SSIS package with an SSIS Environment?
Solved
Executing SSIS package
Best answer by dan.beggs
I figured out that you can call SSISDB.catalog.start_execution synchronously instead of the default of asynchronously. This should give me what I need.
I figured out that you can call SSISDB.catalog.start_execution synchronously instead of the default of asynchronously. This should give me what I need.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
