Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Execute Package Task Properties (General Tab)

SQL Server 2000

  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.

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).

Security Note  When possible, use Windows Authentication.

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).

See Also

Execute Package Task

Show:
© 2015 Microsoft