dtsrun to dtexec Command Option Mapping
New: 5 December 2005
If you have previously used the SQL Server 2000 Data Transformation Services (DTS) dtsrun.exe command prompt utility, this topic will help you understand how the dtsrun command prompt options map to the command prompt options for the new SQL Server 2005 Integration Services dtexec.exe command prompt utility. For suggestions about how to upgrade, see Upgrading dtsrun Command Lines. For more information about the dtexec command options and examples of dtexec syntax, see dtexec Utility.
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. |
See Also
Reference
Other Resources
How to: Run a Package Using the DTExec Utility
How to: Run a Package Using the DTExecUI Utility