Using the MSMQ Destination Component 

The MSMQ Destination Component is an SSIS data flow pipeline component that can be used to send messages to a Microsoft Message Queue. There are four pages of configuration:

  • General
  • Advanced
  • Columns
  • Error Handling

General page

SSIS MSMQ Destination Component

Note about properties:

Several properties in the destination component and the connection manager also exist as advanced fields on the columns page.  Properties set at the component and connection manager level will be applied to every outgoing message.  If any of these properties are also set on the columns page, the columns value will be used instead, potentially allowing a different value for each outgoing message.

Connection Manager

The destination component requires an MSMQ connection manager. The Connection Manager drop-down will show a list of all the KingswaySoft MSMQ connection managers and Microsoft MSMQ connection managers that have been created in the current SSIS package

Time To Be Received

The maximum time in seconds that a message will remain in the queue after it is sent.  If this time expires the message is discarded.

Time To Reach Queue

The maximum time in seconds that a message will take to reach the queue before it is discarded.

Priority

The priority of sent messages.

Connector Type

A GUID defined by the application and used in conjunction with connector applications or message encryption. This GUID allows a receiving application to interpret message properties that were set by the sending application but that are usually set by Message Queuing.  This must be set when any of the following properties/columns are used: AuthenticationProviderName, AuthenticationProviderType, DestinationSymmetricKey, DigitalSignature.

Wrap Messages in XML

Messages written to MSMQ are often XML messages.  If the body of your message is not in XML format, check this option to allow MSMQ to convert to XML format.

Advanced page 

SSIS MSMQ Destination Component - Advanced Page

Use Default Authentication Settings
Determines whether messages should be sent with authentication or not.  Non-default authentication settings can be used by add them as input columns on the columns page.
Encryption Algorithm
The algorithm used to encrypt messages.  If None is selected the message will not be encrypted.
Use Dead Letter Queue
If this option is enabled the message queuing computer that cannot deliver the message before its time-to-reach-queue timer expires will place the undelivered message in the nontransactional dead-letter queue of that computer
Use Journal Queue
Determines if the journal queue will be used for sent messages.  Journal queues store copies of messages that are removed from the queue.
Use Tracing
Determines if tracing should be used for sent messages.

Columns page

The Columns page allows you to map the columns from upstream components to destination attributes.

In the Columns page, you will see a grid as shown below.

SSIS MSMQ Destination Component - Columns Page

  • Input Column - You can select an input column from an upstream component here. 
  • Destination Field - The attribute/field that you want to write data to. 
  • Data Type - This column indicates the type of value for the current attribute. 
  • Unmap - This button provides a convenient way to unset the mapping for the selected attribute/field. 
Add Button
Clicking the Add button will bring up a dialog that will allow advanced fields to be added; this will allow you to set additional properties on outgoing messages.  The values of incoming data for advanced fields will override any matching properties set on the component or connection manager.

Error Handling page 

The Error Handling page allows you to specify how errors should be handled when they happen. 

SSIS MSMQ Destination Component - Error Handling

There are three options available. 

  1. Fail on error
  2. Redirect rows to error output
  3. Ignore error

When the Redirect rows to error output option is selected, rows that failed to write to MSMQ will be redirected to the 'Error Output' of the Destination Component. As indicated in the screenshot below, the green output connection represent rows that were successfully written, and the red 'Error Output' connection represents rows that were erroneous. The 'MsmqErrorMessage' output column found in the 'Error Output' may contain the error message that was reported by MSMQ or the component itself. 

SSIS MSMQ Destination Component - Error Output

NOTE: Use extra caution when selecting Ignore error option, since the component will remain silent for any errors that have occurred.