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:

/~CheckF[ile] filespecThis option sets the CheckpointFileName property on the package to the path and file specified ...

Get Microsoft® SQL Server 2008 R2 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.