How to configure the Delete Raw Data task (Enterprise Manager)

To configure the Delete Raw Data task

1. From the Task toolbar, drag an Execute SQL task onto the Data Transformation Services (DTS) design sheet.
   
   
2. In the Execute SQL Task Properties dialog box, in the Description box, type Delete Raw Data.
   
   
3. In the Existing Connection list, click Raw Data.
   
   
4. In the SQL Statement text box, type the following:

   DELETE FROM RawExpense.
   

5. On the design sheet, right-click Delete Raw Data, point to Workflow, and then click Workflow Properties.
   
   
6. 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
7. Click the Precedence tab, and then add a new entry with Source Step set to Spreadsheet Wait and set Precedence to Success.