DTS Package Properties (Global Variables Tab)
Use this tab to view information about global variables, which can be referenced by any Microsoft® ActiveX® script in a Data Transformation Services (DTS) package. These scripts can be used to customize tasks, workflow steps, and transformations. Global variables defined on this tab remain in scope for the life of the package.
The values of global variables created in this tab are saved with the package. Global variables can also be created dynamically and used in ActiveX scripts; for example:
DTSGlobalVariables("NewGlobalVariable").Value = 5
Global variables created in this manner are not saved with the package and do not appear on the Global Variables tab.
Options
Name
Specify the global variable name. You can edit an existing name, or you can 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.
Explicit Global Variables
Specify that global variables used in ActiveX scripts must be defined in this dialog box or in the Execute SQL Task dialog box before use. By setting Explicit Global Variables, you force yourself to declare every global variable, just as you do in Microsoft Visual Basic® when you turn on Option Explicit.
New
Add a global variable to the package. Clicking New inserts an empty row in the Variables table.
Delete
Delete a selected global variable from the package.