Common SSIS package-Message Queue task

A Message Queue task can receive or send messages to Microsoft Message Queuing (MSMQ. The message format can be a string, a file, or a variable. The advantage of a message queue task is that you can communicate with each other when the package is running. You can use this task to expand the package so that multiple packages can be executed in parallel and the data obtained is verified at the checkpoint. This task can also distribute files through the network. For example, when running, The SSIS package of the received file can download the file to the corresponding SQL server through the office distribution file that the Message Queue cannot figure out.

On the Edit page, you can configure MSMQ connection management through msmqconnection. In the message column, select whether to send or receive messages. On this editing page, you can use use2000format to configure whether to use Windows 2000 MSMQ. The default value of this option is false.

In the send/receive tag interface, select send message in the message tag, and the second tag is send. In the message tag, select receive message to display receive in the second tag. In the receive tag interface, you can set the removefrommessagequeue option to remove a message from the Message Queue after reading the message. The timeoutafter option is used to set whether an error message is generated after the set time is exceeded.

Whether sending or receiving a message, you must set the messagetype option to select whether the message type is string, variable, or data file. In addition, you can convert the received message into a variable when receiving the message.