Message Queue Components are SSIS components which facilitate integration with various message-based services from within SSIS.

Using these components, developers can establish a connection to the message queue and read or write data to the service.

Azure Service Bus Components

IBM MQ/WebSphere MQ Components

  • IBM MQ Connection Manager
    • Establishes the connection to an IBM MQ/WebSphere MQ server.
  • IBM MQ Source Component
    • An SSIS data flow component used to read/retrieve data from an IBM MQ/WebSphere MQ server. Supports retrieving Queue or Topic data with the option to peek at messages or received and delete. Also includes the option to continue retrieving messages until a user defined period of time.
  • IBM MQ Destination Component
    • An SSIS data flow components used to write data to IBM MQ/WebSphere MQ. Supports writing data to Queue or Topic entities.

MSMQ Components

  • MSMQ Connection Manager
    • Used to establish a connection to Microsoft Message Queue.
  • MSMQ Source Component
    • An SSIS data flow component which can be used to read/retrieve data from Microsoft Message Queue with 2 receive modes.
  • MSMQ Destination Component
    • An SSIS data flow component used to write data to Microsoft Message Queue with various options on how messages should be added to the queue such as how long it will remain in the queue and the priority level of the message.

RabbitMQ Components

  • RabbitMQ Connection Manager
    • Used to establish a connection with RabbitMQ.
  • RabbitMQ Source Component
    • An SSIS data flow source component which can be used to read/retrieve data from RabbitMQ with 2 receive modes and the option to continue to retrieve any new messages until a designated time or variable.
  • RabbitMQ Destination Component
    • An SSIS data flow destination component used to send messages to RabbitMQ with options for deliver mode, the priority of the messages and the option to select the encoding that will be used to convert the message body to a byte array.

Youtube Video - Getting started with SSIS Productivity Pack - Azure Service Bus

Youtube Video - Getting started with SSIS Productivity Pack - RabbitMQ

Youtube Video - Getting started with SSIS Productivity Pack - MSMQ

Youtube Video - Getting started with SSIS Productivity Pack - IMB MQ WebSphere MQ