SSIS Package Exercise Steps: Adding Staging Indices Task

1. From Visual Studio 2008, open your Business Intelligence project.

2. From Solution Explorer, double-click the SSIS package to view. The SSIS package appears.

3. To stay on track with the rest of the exercises, open the package created in a previous exercise, BBDW_FACT_INTERACTIONRESPONSE_EXT.dtsx.

4. From the Control Flow, find the Load Rows sequence.

5. Double-click the Adding Staging Indices task. The Execute SQL Task Editor screen appears.

6. From General, under SQL Statement,in the SQLStatement field, highlight the field and click the edit (ellipses) button. The Enter SQL Query screen appears.

7. In the statement, edit the name of the stored procedure to match the one for the table for the SSIS package. Change it from CREATE_OR_DROP_FACT_INTERACTIONRESPONSE_STAGE_INDICES to CREATE_OR_DROP_FACT_INTERACTIONRESPONSE_EXT_STAGE_INDICES.

   This statement executes a stored procedure that creates indexes on the staging table.

   exec BBDW.[CREATE_OR_DROP_FACT_INTERACTIONRESPONSE_EXT_STAGE_INDICES] 1;

8. Click OK twice.

9. Save the package.