Wishbone Pattern

BBDW_DIM_APPEAL.dtsx is an example of an SSIS package for BBDW that follows the Wishbone pattern. "Wishbone" comes from the characteristic shape of the Data Flow in which the tasks "wishbone" after a lookup task. The Data Flow in a BBDW package usually occurs in a Sequence in the Control Flow called Load Rows. Here is a visualization of the Wishbone pattern's Data Flow in Visual Studio:

The Control Flow for the package follows some basic patterns for BBDW packages. There are three Sequences: Pre Processing, Load Rows, and ETL Post Processing. Patterns for these Sequences in templates are discussed in Package Template. Here is a visualization for the package's Control Flow in Visual Studio: