Export (0) Print
Expand All

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.

Community Additions

ADD
Show:
© 2014 Microsoft