Running Packages

The dtexec options are additive. Depending on what you are trying to do, you are able to string one or more options and their values together in the following form:

dtexec /option [value] [/option [value]] ...

To show available options for dtexec, you use '/?' or '/H' or '/Help'. Alternatively, you can see the details for a particular option by using the available options indicator followed by the option name ('/?' [option name]). This invokes SQL Server Books online for that particular option. Note that a dash (-) may be substituted for / in this command.

The dtexec package execution options include the following:

/~Ca[llerInfo]—This option specifies additional information for a package execution. ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.