Export (0) Print
Expand All
Expand Minimize

Execute Package Task Properties (Child Package Globals Tab)

SQL Server 2000

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.



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


Specify the global variable data type from the list.


Specify the initial value assigned to the variable.


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


Delete a selected global variable from the package.

See Also

Execute Package Task

Using Global Variables with DTS Packages

© 2014 Microsoft