Merge Pattern

BBDW_FACT_INTERACTIONRESPONSE.dtsx is an example of an SSIS package for BBDW that follows the Merge pattern. "Merge" comes from the characteristic use of a Transact-SQL MERGE statement. 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 Merge 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