How to configure the Spreadsheet Wait task (Enterprise Manager)

To configure the Spreadsheet Wait task

1. From the Task toolbar, drag a Message Queue task onto the Data Transformation Services (DTS) design sheet.
   
   
2. In the Message list, click Receive Message.
   
   
3. In the Queue box, enter the name of the computer_name\queue_type$\queue_name combination that identifies the queue where expense worksheets will be sent.
   
   
4. In the Message Type list, click Data File Message.
   
   
5. In the Save file as box, type C:\Temp\Expense.xls.
   
   
6. Do the following:
   • Select the Overwrite check box to prevent the first worksheet from blocking further uploads.
     
     
   • Select the Remove from message queue check box or the package will loop indefinitely as it repeatedly attempts to load the same worksheet.
     
     
   • Clear the Timeout after check box because this package runs until canceled.
7. On the design sheet, right-click Wait, point to Workflow, and then click Workflow Properties.
   
   
8. 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