Executing Synchronously from DtExec

Five years ago, I wrote a blog post titled The SYNCHRONIZED SSIS Execution Parameter. Recently, I received a comment with a question:

One way to execute SSIS packages stored in the SSIS Catalog from SQL Agent is to use the CmdExec job step type. As with all command-level access, please research security implications.

Use a command similar to that shown below to override the SYNCHRONIZED SSIS Catalog execution parameter value:

dtexec /ISServer "\SSISDB\Folder\Project\Package.dtsx" /Server "server\instance" /Par $ServerOption::SYNCHRONIZED(Boolean);"true"

Please keep the questions coming!

Hope this helps,

Andy

Andy Leonard

andyleonard.blog

Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, Azure Data Factory, SSIS, and Biml guy. I was cloud before cloud was cool. :{>