Data Warehouse Patterns - SQL Server Integration Services Design Patterns - page 321

these. Although there are similarities, there are enough differences to justify separating
the logic into different sandboxes.
For the control flow elements of the historical load, this incremental load pattern
will also use two CDC Control tasks with a data flow between them. We'll need to
slightly change the configuration of these tasks so that we retrieve and then update the
current processing range of the CDC operation. As shown in Figure 11-6 , we'll set the
operation for the first of these as Get Processing Range, which would be followed by
Update Processing Range after the incremental load is complete.
Figure 11-6 . Get processing range for CDC incremental load
Note The CDC Control task is a versatile tool that includes several processing
modes to handle various CDC phases, including dealing with a snapshot database or
quiescence database as a source. A complete listing of the processing modes can be
found here: http://msdn.microsoft.com/en-us/library/
hh231079.aspx .
Within the data flow, the CDC Source should be set with the table from which to
capture, the capture instance, and the processing mode. In this case, we're going to use
“Net” to retrieve the net changes to the CDC table. See Figure 11-7 .