SSIS Package Exercise Steps: Mark LoadStatus Complete

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.

   In this exercise you view the Mark LoadStatus Complete 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 UPDATE statement for the ETLCONTROL which sets LOADISCOMPLETE = 1.