Message Queue Task

Microsoft Message Queuing (MSMQ) is a Windows service that allows applications or SSIS packages to send and receive messages using a queue. Message queuing is available in Windows 2000 and later released as a standard operating system component that has advantages of Active Directory Integration. This service can be extended using Message Queuing Connector to heterogeneous data sources such as CICS (IBM’s Customer Information Control System) or UNIX.

In SSIS world, message queuing means one package will be sending a message to a queue while other package will be receiving that message from the queue. These packages can be on different servers and may not be running simultaneously. Using MSMQ, you can reliably exchange data ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.