How to configure the New Employee task (Enterprise Manager)

How to configure the New Employee task (Enterprise Manager)

To configure the New Employee task

1. From the Task toolbar, drag a Message Queue task onto the Data Transformation Services (DTS) design sheet.
   
   
2. In the Message Queue Task Properties dialog box, in the Description box, type New Employee.
   
   
3. In the Message box, click Receive Message.
   
   
4. In the Queue box, enter the name of the computer_name\queue_type$\queue_name combination to identify the queue at which global variable messages will be received.
   
   
5. In the Message type list, click Global Variables Message, and then click No filter.
   
   
6. Specify the following options:
   • Select the Remove from message queue check box or the DTS package will loop indefinitely as it repeatedly attempts to add the same employee.
     
     
   • Select the Timeout after check box to force package termination after the queue is emptied, and then in the seconds box, type 1.
7. On the design sheet, right-click New Employee, point to Workflow, and then select Workflow Properties.
   
   
8. In the Workflow Properties dialog box, click the Options tab, and then clear the following check boxes:
   • Join transaction if present
     
     
   • Commit transaction on successful completion of this step
     
     
   • Rollback transaction on failure