SSIS Package Exercise Steps: Add Indices Task

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

   Note: For information about the version of Visual Studio to use, see Visual Studio Versions for Custom Packages.

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

   Note: 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.