Export (0) Print
Expand All

Command Prompt Utilities (SSIS)

Updated: 15 September 2007

Microsoft SQL Server 2005 Integration Services (SSIS) includes command prompt utilities for running and managing Integration Services packages.

ms140258.note(en-US,SQL.90).gifNote:
On a 64-bit computer, Integration Services installs both a 32-bit and a 64-bit version of dtexec.exe and dtutil.exe. The Execute Package Utility, dtexecui.exe, is available only in a 32-bit version.

You can use the Execute Package Utility dialog box to specify package run-time configurations and run packages on the local computer. You also can use this utility to generate command lines for use with the dtexec command prompt utility.

To open Execute Package Utility in Integration Services service
  1. Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

  2. In the Connect to Server dialog box, select Integration Services in the Server type list, and then click Connect.

  3. Expand the Stored Packages folder and subfolders, right-click the package you want to run, and then click Run Package.

You can also open the Execute Package utility at the command prompt by typing dtexecui.

For more information about the options you can set in the Execute Package Utility dialog box, click one of the following topics:

Execute Package Utility (General Page)

Execute Package Utility (Configurations Page)

Execute Package Utility (Command Files Page)

Execute Package Utility (Connection Managers Page)

Execute Package Utility (Execution Options Page)

Execute Package Utility (Reporting Page)

Execute Package Utility (Logging Page)

Execute Package Utility (Set Values Page)

Execute Package Utility (Verification Page)

Execute Package Utility (Command Line Page)

You can use dtexec to run an existing package at the command prompt. You access the utility by running dtexec at a command prompt, and specifying any additional command switches.

For more information, see dtexec Utility.

You can use the dtutil command prompt utility to manage existing packages at the command prompt. You can access packages that are stored in the SQL Server msdb database, the SSIS Package Store, and the file system, and perform tasks such as copying, deleting, moving, and signing packages. You can also verify that a specified package exists.

The dtutil command prompt utility includes the following features:

  • Remarks in the command prompt, which makes the command prompt action self-documenting and easier to understand.
  • Overwrite protection, to prompt for a confirmation before overwriting an existing package when you are copying or moving packages.
  • Console help, to provide information about the command options for dtutil.

If the utility accesses a package that is stored in msdb, the command prompt may require a user name and a password. If the instance of SQL Server uses SQL Server Authentication, the command prompt requires both a user name and a password. If the user name is missing, dtutil tries to log on to SQL Server using Windows Authentication.

The dtutil command prompt utility does not support the use of command files or redirection.

For more information, see dtutil Utility.

Release History

15 September 2007

New content:
  • Added note about 32-bit and 64-bit versions of the utilities.

12 December 2006

New content:
  • Added instructions for opening the Connect to Server dialog box.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft