Receiving Global Variables Messages

Data Transformation Services

Data Transformation Services

Receiving Global Variables Messages

Use global variables messages to transfer variables and their values from one package to another. A global variables message contains the name, type, and value of zero or more variables.

On successful receipt, transmitted variables, with their values, are added to the DTSGLobalVariables collection and the Message Queue task terminates successfully. Previously existing variables with the same name are replaced. You can access newly transmitted variables from Microsoft® Visual Basic® Scripting Edition (VBScript) with DTSGlobalVariables("variable name").

If no acceptable message is initially on the queue, the Message Queue task either waits until one arrives, or fails after the specified timeout interval has passed.

Important  Any change in the package sending the global variables message will result in a new version ID. If you click Filter by version in the Message Queue Task Properties dialog box, messages from the modified package are ignored.

To receive a global variables message with the Message Queue task