Message Queuing Implementation in SSIS

By : Kasim Wirama, MCDBA, MVP SQL Server

SSIS provides tasks that can communicate with other application through windows built in messaging, called Message Queue (MSMQ). The task is Message Queue task. It is used to interact with message queue service. A message can contain file, string or variable. With this task, you can scale up your package, enabling multiple packages sending asynchronous messages to other application. Let’s see what configuration inside the task.

In General page, you specify message queue connection manager. On Message Option property, you specify whether the task is configured to send or receive message. Other property is whether to use windows 2000 MSMQ.

If you choose send message, the Send option will appear on left list box. On Message Type property, you can set what kind of content will be in message, the content could be variable, file or string type.

If you choose receive message, a bit more property will be there, such as time-out property and remove message from queue after read it. For time out property, if it is specified, it will produce error if it experiences a time out.

It is interesting task, I think. If you would like your application to interact one another through loosely coupled, tool or component interact with MSMQ is worth to be considered for use.