Execute Package Task Properties (General Tab)
New Information - SQL Server 2000 SP3.
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.
Type a text label for the Execute Package task, which will appear on the Data Transformation Services (DTS) Designer design sheet.
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
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.
Type the password of the package to be run by the task, if one exists.
View the globally unique identifier (GUID) associated with the package to be run.
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).
Security Note When possible, use Windows Authentication.
Specify a user name for a new connection (SQL Server and Meta Data Services only).
Specify a password for a new connection (SQL Server and Meta Data Services only).