Data Transformation Services

Message Types

A Message Queue task sends and receives the following types of messages:

String Messages

A string message contains a text string. To send a string message, you must specify the message text.

When you configure a Message Queue task to receive a string message, you can specify filtering criteria. You can accept any string message, or you can type a compare string and proceed only if a queued message:

Data File Messages

A data file message contains a Data Transformation Services (DTS) package ID, a version ID, and the name and contents of a data file. To send a data file message, you must specify the path of the file to be sent.

When you configure a Message Queue task to receive a data file message, you must answer the following questions:

Global Variables Messages

A global variables message contains a DTS package ID, a version ID, and the name, type, and value of one or more variables. To send a global variables message, you must add the variables to your package, and then specify them when you configure the Message Queue task.

When you configure a Message Queue task to receive a global variables message, you can specify filtering criteria. You can accept any global variables message, or you can proceed only if a queued message comes from a particular package or package version.