Execute Package Task Properties (Child Package Globals Tab)

DTS Designer

DTS Designer Help

Execute Package Task Properties (Child Package Globals Tab)

Use this tab to specify global variable information that will be passed to the Data Transformation Services (DTS) package to be executed. Make sure that the child package contains definitions for the global variables specified here or the Execute Package task will fail.

Information about global variables is displayed in each row of the Variables table. The buttons at the bottom of the table control the addition or deletion of global variables. You can select a cell in the table to enter or change information.

Options

Name

Specify the global variable name. You can edit an existing name, or type a new name in the cell after clicking New.

Type

Specify the global variable data type from the list.

Value

Specify the initial value assigned to the variable.

New

Add a global variable to the package. Click New to insert an empty row in the Variables table.

Delete

Delete a selected global variable from the package.

See Also

Execute Package Task

Using Global Variables with DTS Packages