September 2010
Intermediate to advanced
1704 pages
111h 8m
English
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] filespec—This option sets the CheckpointFileName property on the package to the path and file specified ...