Using Global Variable Messages to Queue Database Updates

Data Transformation Services

Data Transformation Services

Using Global Variable Messages to Queue Database Updates

The Add New Employees package uses global variable messages to take an employee ID and name from a queue and add the employee to the corporate database. It continues to add employees until the queue is emptied, at which point it stops.

Follow these instructions to create and run this package.

Creating and Configuring the Add New Employees Package

The new package must be created and named. In addition, package properties must be set so that a single failure does not prevent the rest of the new employees from being added.

To create and configure the Add New Employees package