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

To configure the Load Filtered Data task

1. Click Raw Data, and then CTRL-click Corporate.
   
   
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 Final Data.
   
   
4. Under Connection, click SQL query, and then in the text box, type the following SQL statement:

   SELECT FROM RawExpense WHERE ExpenseDate IS NOT NULL 
   

   This generates a source rowset without any null rows.

5. Click the Destination tab, and then in the Table name list, click Expense.
   
   
6. Click the Transformations tab, and then click OK.

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

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