Export (0) Print
Expand All
5 out of 24 rated this helpful - Rate this topic

How to: Run a Package Using the DTExec Utility

This procedure describes how to run a SQL Server 2005 Integration Services (SSIS) package using the dtexec command prompt utility. Using dtexec, you can run packages that are stored either in the file system, in an instance of SQL Server 2005, or in the Integration Services Package Store.

ms138023.note(en-US,SQL.90).gifNote:
On a 64-bit computer, Integration Services installs both a 32-bit and a 64-bit version of the dtexec utility (dtexec.exe).

For information about options to include in a dtexec command line, and some sample command lines, see dtexec Utility.

  1. Open a Command Prompt window.

  2. Type dtexec / followed by the DTS, SQL, or File option and the package path, including the package name.

  3. If the package encryption level is EncryptSensitiveWithPassword or EncryptAllWithPassword, use the Decrypt option to provide the password. If no password is included, dtexec will prompt for the password.

  4. Optionally, provide additional command-line options.

  5. Press the Enter key.

  6. Optionally, view logging and reporting information before closing the Command Prompt window.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.