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

To configure the Load Raw Data task

1. Click Expense Report, and then CTRL-click Raw Data.
   
   
2. On the Task toolbar, click Transform Data Task, and then on the Data Transformation Services (DTS) design sheet, double-click the resulting arrow.
   
   
3. In the Description box, type Load Raw Data, and in the Table/View list, click Expenses to load data from the proper spreadsheet range.
   
   
4. Click the Destination tab, and then in the Table name list, click RawExpense.
   
   
5. Click the Transformations tab, and then click OK.

   Clicking OK without editing the transformations saves the default column mappings.

6. On the design sheet, right-click the Transform Data task, point to Workflow, and then click Workflow Properties.
   
   
7. Click the Options tab, and then do the following:
   • Clear the Commit transaction on successful completion of this step check box.
     
     
   • Clear the Rollback transaction on failure check box.
     
     
   • Select the Join transaction if present check box.
8. Click the Precedence tab, and then add a new entry with Source Step set to Delete Raw Data and Precedence set to Success.