This exercise walks you through the process to create an SSIS package from an existing package. This exercise assumes you have created a Business Intelligence project and have access to existing Blackbaud Product Development SSIS packages.
For this and other SSIS package exercises, the exercises assume database revisions have been created along the lines of the exercises in that section. Recall that in those exercises, database revisions were created to add a staging and warehouse table that closely mirrors FACT_INTERACTIONRESPONSE. If you are completing these exercises separately, remember that the purpose of these exercises is demonstrate the ETL extensions for extension tables in a BBDW database. In other words, creating database revisions extensions and creating ETL extensions are intertwined.
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.