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.

    Ważne:
    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.

  [!UWAGA]

  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.

Zobacz także

Koncepcje

dtexec Utility