SSIS Package Exercise Steps: Modify Truncate Staging 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 a previous exercise, BBDW_FACT_INTERACTIONRESPONSE_EXT.dtsx.

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

  4. Double-click the Truncate Staging 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 first statement, edit the name of the staging table to match the staging table for this SSIS package.

  7. In the second statement, edit the name of the stored procedure to match the staging table for this SSIS package.

    Truncating the table and dropping its indexes is a way of initializing a staging table. The query should look like this:

    truncate table BBDW.[FACT_INTERACTIONRESPONSE_EXT_STAGE];

exec BBDW.[CREATE_OR_DROP_FACT_INTERACTIONRESPONSE_EXT_STAGE_INDICES] 0;

  8. Click OK twice.

  9. Save the package.