Execute Package Task Properties (General Tab)
Use the Execute Package task to specify another Data Transformation Services (DTS) package to run as part of package execution, and to pass information contained in parent package global variables to the child package.
Options
Description
Type a text label for the Execute Package task, which will appear on the Data Transformation Services (DTS) Designer design sheet.
Location
Specify how the package that will be run by the Execute Package task was saved:
To Microsoft® SQL Server™
To SQL Server 2000 Meta Data Services
To a structured storage file
Package name
Type the name of the package to be run by the task, or browse for the package.
Note If you select a specific version of the package to be run in the Select Package dialog box, you will always execute that version of the package. If you select a package node in the Select Package dialog box, the latest version of the selected package is always run.
Password
Type the password of the package to be run by the task, if one exists.
Package ID
View the globally unique identifier (GUID) associated with the package to be run.
Server
Select the name of the server containing the external package to be run from the list of available servers (SQL Server and SQL Server Meta Data Services only).
Use Windows Authentication
Specify Windows Authentication for login (SQL Server and Meta Data Services only).
Use SQL Server Authentication
Specify SQL Server Authentication for login (SQL Server and Meta Data Services only).
User name
Specify a user name for a new connection (SQL Server and Meta Data Services only).
Password
Specify a password for a new connection (SQL Server and Meta Data Services only).