The Message Queue Task enables you to send or receive messages from Microsoft Message Queuing (MSMQ) right out of the box. For integration with other messaging systems like IBM’s MQ Series or Tibco’s Rendezveus, you need to either code to a library within a Script Task, create a custom component, or execute T-SQL statements to a SQL Server Service Broker queue. Messaging architectures are created to ensure reliable communication between two disparate subsystems. A message can be a string, a file, or a variable. The main benefit to using this task is the capability to make packages communicate with each other at runtime.
- Chapter 3: SSIS Tasks
- from Professional Microsoft SQL Server 2012 Integration Services
- Publisher: Wrox
- Released: March 2012
This feature is very important as it enables different system to communicate to each other and provide architectural level design support.
Share this highlighthttp://www.safaribooksonline.com/a/professional-microsoft-sql/6704790/