SSIS Package Exercise Steps: View ETL Run Variables Task and Referenced Stored Procedure

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.

   In this exercise you will view the ETL Run Variables task, a housekeeping task. Usually you will not need to modify housekeeping tasks in an SSIS package based on a Blackbaud Product Development template.

3. From the Control Flow, find the Pre Processing sequence.

4. Double-click the ETL Run Variables task. The Execute SQL Task Editor screen appears.

5. From General, under SQL Statement, move your cursor over the SQL Statement. The full statement appears as a tool-tip.

6. Note the name of the stored procedure the SQL statement executes, BBDW.USP_ETL_BEGINLOAD.

7. From SQL Server Management Studio, find the stored procedure, BBDW.USP_ETL_BEGINLOAD.

   1. Connect to the database.

   2. From Object Explorer, expand nodes as follows: Databases > [Database name] > Programmability > Stored Procedures.

   3. Right-click the stored procedure, and click Modify. A query to modify the procedure appears.

   4. Examine the procedure.