Message Types

Data Transformation Services

Data Transformation Services

Message Types

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

  • String message

  • Data file message

  • Global variables message
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:

  • Matches the compare string exactly.

  • Matches the compare string (ignoring case).

  • Contains the compare string.
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:

  • Is the file to be saved under its original name or with a name you specify?

  • Do you want the Message Queue task to overwrite an existing file?

  • Will you accept files from any source or limit them to only those sent from a particular package or package version?
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.