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, SSIS and Biml guy. I was cloud before cloud was cool. :{>

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.