Andy I'am enjoing the series but I have a small problem with the 'Update'.
I'ts working, but it only updates about 700 records each run, I can't find any option to change this behavior.
The only thing I can imagine is that I use a very limited virtual server and that this is caused by the Full Cache option of the Lookup.
But I see the correct number of records at each Data Flow.
I do see 2 warnings, but I don't think they have any thing to do with the update problem:
[SSIS.Pipeline] Warning: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.
and
[SSIS.Pipeline] Warning: The output column "LkUp_BusinessEntityID" (131) on output "Lookup Match Output" (103) and component "Lookup" (101) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Rob