Add an SSIS Package Based on an Existing Blackbaud Product Development Package

  1. From Visual Studio, open your Business Intelligence project.

    Note: For information about the version of Visual Studio to use, see Visual Studio Versions for Custom Packages.

  2. From Solution Explorer, right-click SSIS Packages.

  3. Click Add Existing Package. The Add Copy of Existing Package screen appears.

  4. 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.

  5. From Package location, select "File System."

  6. 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.

  7. Click OK. A copy of the package is added to your solution's SSIS Packages folder.

  8. Rename the package: BBDW_FACT_INTERACTIONRESPONSE_EXT.dtsx