Hi Sam,

the For Each Loop is configured for unique date in source. It will process records for each date starting from the earliest.

On any given day I can see 300-1200 dates.

For each date it will call the stage dataflow to assemble the data for that date. Then the Load data flow (using Stage) to check for possible changes to the target (type 2)

All source and Destination transforms in the dataflows are OLEDB.

The reason I am not doing one set based stage and load is that I need the updates from one date applied to the final target before processing the next date.

This way I can identify if the record has changes before updating (type 2) as I go through each date.