DTS Programming

GlobalVariable Object

The GlobalVariable object defines a variable that allows data to be shared across steps and Microsoft® ActiveX® scripts.

Collections
Properties Collection

Properties
Name Property Value Property
Parent Property  

Remarks

Global variables can be shared between Data Transformation Services (DTS) packages by using the ExecutePackageTask or DTSMessageQueueTask objects.

The GlobalVariable object is compatible with Microsoft® SQL Server™ version 7.0. For more information about an extended version of this object, see GlobalVariable2 Object.

See Also

Adding DTS Lookups and Global Variables

DTSMessageQueueTask Object

ExecutePackageTask Object

GlobalVariables Collection