Mapping dtsrun Options to dtexec Options
In SQL Server Integration Services, the dtsrun command prompt utility (dtsrun.exe) that was used in SQL Server 2000 Data Transformation Services (DTS) has been replaced by the dtexec command prompt utility (dtexec.exe).
If you have previously used the DTS dtsrun utility, this topic will help you understand how the dtsrun options map to the options for the Integration Services dtexec utility.
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 the dtexec command options and examples of dtexec syntax, see dtexec Utility (SSIS Tool).
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).
dtsrun Options That Have a dtexec Equivalent
Dtsrun Option |
Dtexec Option |
Description |
|---|---|---|
/? |
/? Or /H[ELP] |
Display list of options. |
/S |
/Ser[ver] |
Specify server name. |
/U |
/U[ser] |
Specify user name. |
/P |
/P[assword] |
Provide the user password. |
/N |
/SQ[L] /D[ts] – package store |
Specify the package name in MSDB. |
/G |
/VerifyP[ackageID] |
Provide the package GUID. |
/V |
/VerifyV[ersionID] /VerifyB[uild] |
Specify the package version and build. |
/M |
/De[crypt] |
Specify the package password. |
/F |
/F[ile] – file system /D[ts] – package store |
Specify the file name of the package. |
/A |
/Set |
Specify the value of a variable. |
/L |
/L[ogger], /Cons[oleLog] |
Log to log file or log provider. |
/W |
/L[ogger] , /Cons[oleLog] |
Log to Event Log. |
dtsrun Options That Do Not Have a dtexec Equivalent
Dtsrun Option |
Dtexec Option |
Description |
|---|---|---|
/E |
(Omit user name and password) |
Use a trusted connection. |
/R |
(The Repository is not supported) |
Specify Repository database name. |
/Z |
Pass in encrypted command line |
|
/!X |
Block execution when creating an encrypted command line. |
|
/!D |
(Use Dtutil.exe) |
Delete package from MSDB database. |
/!Y |
Display encrypted command line without executing it. |
|
/!C |
Copy command line to the clipboard. |
New dtexec Options That Do Not Have a dtsrun Equivalent
Dtsrun Option |
Dtexec option |
Description |
|---|---|---|
/CheckF[ile] |
Specify a checkpoint file. |
|
/CheckP[ointing] |
Turn checkpointing on or off. |
|
/Com[mandFile] |
Specify a file that contains additional command-line options. |
|
/Conf[igFile] |
Specify a configuration file. |
|
/Conn[ection] |
Provide a connection string for a connection manager in the package. |
|
/M[axConcurrent] |
Set the maximum number of concurrent executables. |
|
/Rem |
Enter a comment. |
|
/Rep[orting] |
Set the reporting level. |
|
/Res[tart] |
Specify how to handle checkpoints. |
|
/Su[m] |
Display rowcount. |
|
/Va[lidate] |
Validate without executing. |
|
/VerifyS[igned] |
Fail if not signed. |
|
/W[arnAsError] |
Treat a warning as an error and a validation failure. |
|
.gif "Integration Services icon (small)")
Stay Up to Date with Integration Services