Execute Package Utility (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.
- 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.
- 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.
See Also
Reference
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)
Other Resources
Command Prompt Utilities (SSIS)
dtexec Utility
Running Packages