Data Transformation Services
Message Queue Task Examples
The following package examples illustrate the use of the Message Queue task with each message type:
- The Prepare Facts and Update Warehouse packages use string messages to coordinate operations on two computers.
- The Add New Employees package uses global variable messages to retrieve new employee information from a queue and save it in a database.
- The Load Expenses package uses data file messages to take Microsoft® Excel worksheets from a queue, extract expense data, and save it in a database.