Sending Messages with the Message Queue Task

Data Transformation Services

Data Transformation Services

Sending Messages with the Message Queue Task

Use the Message Queue task to place one or more messages on a queue for later delivery to DTS packages running on this or other computers.

The Message Queue task will fail at run time if:

  • The queue name is entered incorrectly or the named queue is not on your network.

  • A data file message references an unavailable or nonexistent data file.

  • A message contains more than 4 megabytes (MB).

    Data files and variables must use slightly less than 4 megabytes in order to accommodate any included package or version IDs, file names, or variable names and types.

Important  A Message Queue task is not allowed to take part in the package transaction. As a result, your package will fail at run time if, in the Workflow Properties dialog box for a Message Queue task, you select the Join transaction if present check box.

To send a message with the Message Queue Task