~D¥ package_path- This option is used to load a package from the SSIS package store. With this value set, the source names or GUIDs that are specified are not logged. The value E src_name_or_guid parameter specified for inclusion or exclusion is an event name, a source name, or a source GUID. Source names or GUIDs that are specified are logged. The displayoptions values are N (name), C (computer), O (operator), S (source name), G (source GUID), X (execution GUID), M (message), and T (time start and end). ]- This option displays specified log entries to the console during package execution. This option specifies the specific connection manager name or GUID and Using this option, you can set a runtime configuration that differsįrom the configuration specified for the package at design time. This option specifies a configuration file to extract values from. The filespec argument specifies the filename and path of the command file to associate with the execution of the package. filespec is a text file that contains additional dtexec command options. ~Com filespec- This option specifies that during the command sourcing phase of the utility, the file specified in filespec is opened, and options from the file are read until the EOF is found in the file. Using the /CheckPointing on option of dtexec is equivalent to setting the SaveCheckpoints property of the package to True and the CheckpointUsage property to Always. If this option is not specified, the value set in the package is retained. Package execution fails if the value is set to on and the checkpoint file cannot be found. The default value is on if the option is declared without a value. Is rerun, the runtime engine uses the checkpoint file to restart the Specifies that a failed package is to be rerun. This file is used when the package restarts. ~CheckF filespec- This option sets the CheckpointFileName property on the package to the path and file specified in filespec. The dtexec package execution options include the following: That a dash (-) may be substituted for / in this command. This invokes SQL Server Books online for that particular option. The available options indicator followed by the option name ('/? ). Īlternatively, you can see the details for a particular option by using To show available options for dtexec, you use '/?' or '/H' or '/Help'.