Converting dtsrun Command Lines to dtexec Command Lines
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]
The Data Transformation Services (DTS) dtsrun command prompt utility (dtsrun.exe) has been replaced in Integration Services by the dtexec utility (dtexec.exe).
To convert your dtsrun command lines, you can map each command-line option to the corresponding dtexec option. However, not all command-line options are available in both utilities:
- Some dtsrun command-line options have direct dtexec equivalents. For example, there are dtexec equivalents for the options that provide a server name or package name, and the options for setting the value of a variable.
- Some dtsrun command-line options do not have direct dtexec equivalents. For example, the dtsrun command-line option to specify a trusted connection is now the implicit default, and the dtsrun command-line option to load from the Repository is no longer supported.
- There are some new dtexec command-line options that support new features in Integration Services, such as the options to pass in connection strings and to manage checkpoints.
For more information about how to map dtsrun command lines, see Mapping dtsrun Options to dtexec Options.
For more information about the dtexec command options and examples of dtexec syntax, see dtexec Utility.
If you want to create new command lines visually with the assistance of a user interface, use the Execute Package Utility (dtexecui.exe). This utility displays all the available options and ensures the use of the correct syntax.
Note
In Integration Services, the Execute Package Utility (dtexecui.exe) replaces the DTS dtsrunui utility (dtsrunui.exe).