From Visual Studio 2008, open your Business Intelligence project.
From Solution Explorer, right-click SSIS Packages.
Click Add Existing Package. The Add Copy of Existing Package screen appears.
Find the package to copy. This set of exercises creates ETL extensions for FACT_INTERACTIONRESPONSE_EXT, a table created through revisions created in another set of exercises.
FACT_INTERACTIONRESPONSE_EXT closely mirrors FACT_INTERACTIONRESPONSE. Therefore a good starting point is the package for FACT_INTERACTIONRESPONSE.
From Package location, select "File System."
From Package path, browse to location of the package.
Look in your SQL Server folder within Packages\BBETL\<Database name>. For example, C:\Program Files\Microsoft SQL Server\100\DTS\Packages\BBETL\Shelby_RPT_BBDW\BBDW_FACT_INTERACTIONRESPONSE.
Package names follow the convention BBDW_<Table name>.dtsx.
Click OK. A copy of the package is added to your solution's SSIS Packages folder.
Rename the package: BBDW_FACT_INTERACTIONRESPONSE_EXT.dtsx