You can start from scratch, base your SSIS packages on existing Blackbaud Product Development packages, or use a package template provided by Blackbaud. The package templates follow the Merge pattern for BBDW SSIS packages. A package template contains three control sequences: Pre Processing, Load Rows, and ETL Post Processing. A package template for a dimension and a fact are provided. The package templates are:
From a Business Intelligence project in Visual Studio 2008, you can add an SSIS package to a solution based on an existing package. The makes it easy to create new SSIS packages that follow Blackbaud Product Development patterns.