SSIS Package Exercise Steps: Adding 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.

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

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

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

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

6. In the statement, edit the name of the stored procedure to match the one for the table for the SSIS package.

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

   exec BBDW.[CREATE_OR_DROP_FACT_INTERACTIONRESPONSE_EXT_INDICES] 1;

7. Click OK twice.

8. Save the package.