How to: Run a Package Using the DTExec Utility

  • Article

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.

Note

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.

To run a package using dtexec

  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.

See Also

Tasks

How to: Run a Package Using the DTExecUI Utility
Running Packages

Concepts

Package How-to Topics (SSIS)

Help and Information

Getting SQL Server 2005 Assistance