Share via


Execute Package Utility (DtExecUI) UI Reference

Use the Execute Package Utility to run Integration Services packages. The utility runs packages that are stored in one of three locations: Microsoft SQL Server database, the SSIS Package Store, and the file system. This user interface, which can be opened from SQL Server Management Studio or by typing dtexecui at a command prompt, is an alternative to running packages by using the DTExec command prompt tool.

Packages execute in the same process as the dtexecui.exe utility. Because this utility is a 32-bit tool, packages run by using dtexecui.exe in a 64-bit environment run in Windows on Win32 (WOW). When developing and testing commands by using the dtexecui.exe utility on a 64-bit computer, you should test the commands in 64-bit mode by using the 64-bit version of dtexec.exe before deploying or scheduling the commands on a production server.

The Execute Package Utility is a graphical user interface for the DTExec command prompt tool. The user interface makes it easy to configure options and it automatically assembles the command line that is passed to the DTExec command prompt tool when you run the package from the specified options.

The Execute Package Utility can also be used to assemble command lines that you use when running DTExec directly.

To open Execute Package Utility in SQL Server Management Studio

  1. In SQL Server Management Studio, on the View menu, click Object Explorer.

  2. In Object Explorer, click Connect, and then click Integration Services.

  3. In the Connect to Server dialog box, enter the server name in the Server name list, and then click Connect.

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

To open the Execute Package Utility at the Command Prompt

  • In a command prompt window, run dtexecui.

The following sections describe pages of the Execute Package Utility dialog box.

General Page

Use the General page of the Execute Package Utility dialog box to specify a package name and location.

The Execute Package utility (dtexecui.exe) always runs a package on the local computer, even if the package is saved on a remote server. If the remote package uses configuration files that also are saved on the remote server, then the Execute Package utility may not locate the configurations and the package fails. To avoid this problem, the configurations must be referenced by using a Universal Naming Convention (UNC) share name like \\myserver\myfile.

Static Options

  • Package source
    Specify the location of the package to run, using the following options:

    Value

    Description

    SQL Server

    Select this option when the package resides in Microsoft SQL Server. Specify an instance of SQL Server and provide a user name and password for SQL Server Authentication. Each user name and password adds the /USER username and /PASSWORD password options to the command prompt.

    File system

    Select this option when the package resides in the file system.

    SSIS Package Store

    Select this option when the package resides in the SSIS Package Store.

    Each of these selections has the following set of options.

  • Execute
    Click to run the package.

  • Close
    Click to close the Execute Package Utility dialog box.

Dynamic Options

Package Source = SQL Server

  • Server
    Type the name of the server where the package resides, or select a server from the list.

  • Log on to the server
    Specify whether the package should use Windows Authentication or SQL Server Authentication to connect to SQL Server. Windows Authentication is recommended for better security. With Windows Authentication you do not have to specify a user name and password.

    • Use Windows Authentication
      Select this option to use Windows Authentication and log on using a Microsoft Windows user account.

    • Use SQL Server Authentication
      Select this option to use SQL Server Authentication. When a user connects with a specified login name and password from a non-trusted connection, SQL Server performs the authentication by checking to see if a SQL Server login account has been set up and if the specified password matches the one previously recorded. If SQL Server cannot find the login account, authentication fails, and the user receives an error message.

      Important

      When possible, use Windows Authentication.

  • Package
    Type the name of the package, or click the ellipsis button (…) to locate a package using the Select an SSIS Package dialog box.

Package Source = File System

  • Package
    Type the name of the package, or click the ellipsis button (…) to locate a package using the Open dialog box. By default, the dialog box lists only files that have the .dtsx extension.

Package Source = SSIS Package Store

  • Server
    Type the name of the computer where the package resides, or select a computer from the list.

  • Log on to the server
    Specify whether the package should use Microsoft Windows Authentication to connect to the package source. Windows Authentication is recommended for better security. With Windows Authentication you do not have to specify a user name and password.

    • Use Windows Authentication
      Select this option to use Windows Authentication and log on using a Microsoft Windows user account.

    • Use SQL Server Authentication
      This option is not available when you run a package stored in the SSIS Package Store.

  • Package
    Type the name of the package, or click the ellipsis button (…) to locate a package using the Select an SSIS Package dialog box.

Configurations Page

Use the Configurations page of the Execute Package Utility dialog box to select the configuration files to load at run time, and to specify the order in which they load.

Options

  • Configuration files
    Lists the configurations that the package uses. Each configuration file adds a /CONFIGFILE filename option to the command prompt.

  • Arrow keys
    Select a configuration file in the list, and use the arrow keys at right to change the loading order. Configurations load in order starting from the top of the list.

    Note

    If multiple configurations modify the same property, the configuration that loads last is used.

  • Add
    Click to add configurations using the Open dialog box. By default, the dialog box lists only files that have the .dtsconfig extension.

  • Remove
    Select a configuration file in the list and then click Remove.

  • Execute
    Click to run the package.

  • Close
    Click to close the Execute Package Utility dialog box.

Command Files Page

Use the Command Files page of the Execute Package Utility dialog box to select the command files to load at run time.

Options

  • Command files
    Lists the command files that the package uses. A package can use multiple files to set command-line options.

  • Arrow keys
    Select a command file in the list, and use the arrow keys at right to change the loading order. Command files load in order, starting from the top of the list.

  • Add
    Click to add a command file, using the Open dialog box.

  • Remove
    Select a command file in the text box, and then remove it using the Remove button.

  • Execute
    Click to run the package.

  • Close
    Click to close the Execute Package Utility dialog box.

Connection Managers Page

Use the Connection Managers page of the Execute Package Utility dialog box to edit the connection strings of the connection managers that the package uses.

Options

  • Connection Manager
    Select its check box to make the Connection String column editable.

  • Description
    View a description for each connection manager. Descriptions cannot be edited.

  • Connection String
    Edit the connection string for a connection manager. This field is editable only when the Connection Manager check box is selected.

  • Execute
    Click to run the package.

  • Close
    Click to close the Execute Package Utility dialog box.

Execution Options Page

Use the Execution Options page of the Execute Package Utility dialog box to specify run-time options for the package.

Options

  • Fail package on validation warnings
    Indicate whether the package fails if a validation warning occurs.

  • Validate package without executing
    Indicate whether the package is validated only.

  • Maximum concurrent executables
    Indicate whether you want to specify the maximum number of executables that can run in the package at the same time. After you select this check box, use the spin box to specify the maximum number of executables.

  • Enable package checkpoints
    Indicate whether to enable package checkpoints.

  • Checkpoint file
    List the checkpoint file the package uses, if you enable package checkpoints.

  • Browse
    Click the browse button (…) to locate the checkpoint file using the Open dialog box, if you enable package checkpoints. If a checkpoint file is already specified, it is replaced by the selected file.

  • Override restart options
    Indicate whether to override restart options, if you enable package checkpoints.

  • Restart option
    Select how to use checkpoints, if you override restart options.

  • Execute
    Click to run the package.

  • Close
    Click to close the Execute Package Utility dialog box.

Reporting Page

Use the Reporting page of the Execute Package Utility dialog box to specify the events and information about the package to log to the console when the package runs.

Options

  • Console events
    Indicate the events and types of messages to report.

    • None
      Select for no reporting.

    • Errors
      Select to report error messages.

    • Warnings
      Select to report warning messages.

    • Custom Events
      Select to report custom event messages.

    • Pipeline Events
      Select to report data flow events messages.

    • Information
      Select to report information messages.

    • Verbose
      Select to use verbose reporting.

  • Console logging
    Specify the information that you want written to the log when the selected event occurs.

    • Name
      Select to report the name of the person who created the package.

    • Computer
      Select to report the name of the computer the package is running on.

    • Operator
      Select to report the name of the person who started the package.

    • Source name
      Select to report the package name.

    • Source GUID
      Select to report the package GUID.

    • Execution GUID
      Select to report the GUID of the package execution instance.

    • Message
      Select to report messages.

    • Start time and end time
      Select to report when the package began and finished.

  • Execute
    Click to run the package.

  • Close
    Click to close the Execute Package Utility dialog box.

Logging Page

Use the Logging page of the Execute Package Utility dialog box to make log providers available to the package at run time. Provide the package log provider type and the connection string for connecting to the log. Each log provider entry adds a /LOGGER classid option to the command prompt.

Options

  • Log Provider
    Select a log provider from the list.

  • Configuration String
    Select the name of the connection manager from the package that points to the log location, or type the connection string for connecting to the log provider.

  • Remove
    Select a log provider and click to remove it.

  • Execute
    Click to run the package.

  • Close
    Click to close the Execute Package Utility dialog box.

Set Values Page

Use the Set Values page of the Execute Package Utility dialog box to set the property values of packages, executables, connections, variables, and log providers by typing the paths of properties and the property values. Each path entry adds a /SET propertypath;value option to the command prompt.

Options

  • Property Path
    Type the path of the property. The path syntax uses a backslash (\) to indicate that the following item is a container, the period (.) to indicate the following item is a property, and brackets to indicate a collection member. The member can be identified by its index or its name. For example, the property path of a package variable is \Package.Variables[MyVariable].Value.

  • Value
    Type the value of the property.

  • Remove
    Select a property path and click to remove it.

  • Execute
    Click to run the package.

  • Close
    Click to close the Execute Package Utility dialog box.

Verification Page

Use the Verification page of the Execute Package dialog box to set criteria for verifying the package.

Options

  • Execute only signed packages
    Select to execute only packages that have been signed.

  • Verify package build
    Select to verify the package build.

    • Build
      Specify the sequential Build number associated with the build.
  • Verify package ID
    Select to verify the package ID.

    • Package ID
      Specify the package identification number.
  • Verify version ID
    Select to verify the version ID.

    • Version ID
      Specify the version identification number.
  • Execute
    Click to run the package.

  • Close
    Click to close the Execute Package Utility dialog box.

Command Line Page

Use the Command Line node of the Execute Package Utility dialog box to edit the command line that has been generated by the options created by the various dialogs.

Options

  • Restore the original options
    Click to restore the command line to its original state. Use this option if you have made modifications using the Edit the command line manually option and want to restore the original command-line options.

  • Edit the command line manually
    Click to edit the command line in the Command line text box.

  • Command line
    Displays the current command line. Editable if you selected the option to edit the command line manually.

  • Execute
    Click to run the package.

  • Close
    Click to close the Execute Package Utility dialog box.

See Also

Concepts

dtexec Utility