In this exercise you will modify the Upsert task. The Upsert task loads data from the staging table into the warehouse table. This exercise assumes you have created a Business Intelligence project and have access to an SSIS package based on a Blackbaud template.
If you require additional information about this type of project and Business Intelligence Development Studio in general, see Microsoft's MSDN article, Introducing Business Intelligence Development Studio.