Message Queue Task Examples

From Data Transformation Services

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.