Skip to content

Matt Masson

SQL Server Integration Services (SSIS), Power Query (PQ), Azure Data Factory (ADF), and general Data Integration

Server Execution Parameters with DTEXEC

  • Home
  • 2013
  • June
  • Server Execution Parameters with DTEXEC
SQL Server MattJune 23, 2013

The SSIS team blogged about executing packages deployed to the SSIS Catalog using DTEXEC a while ago. The post mentions the $ServerOption::SYNCHRONIZED parameter as a way to control whether the execution is synchronous or asynchronous, but there are some other server options you can set as well. Phil Brammer actually blogged about the options last year. You can also see the full list of options when you view the SSIS Catalog Execution report (note the Parameters Used section in the screenshot below).

image

These options can be specified on the command line when you run a catalog package with DTExec. For example, to change the logging level to VERBOSE (3) for a specific execution, you’d add the following to your dtexec command:

/Par "$ServerOption::LOGGING_LEVEL(Int32)";3

More information on logging levels can be found here.

SSISSSISDB

Post navigation

SQL Saturday Dublin – this weekend!
Filtering in Data Explorer

Copyright © 2021 | All Rights Reserved. CorpoNotch by Shark Themes