First off, great series. My problem is this. I built the lookup operation verbatim, but it's giving me the following error:
"The component has detected a potential metadata corruption during validation. Error at Load tblDest [Correlate ]: The Correlate.Outputs[Lookup Match Output] has an invalid error or truncation row disposition.
It may not be possible to recover to a valid state using a component specific editor. Do you want to use the Advanced Editor dialog bog for editing this component?"
I opened up the advanced editor for the lookup, and I think the problem is that the NoMatchBehavior is being set as "Treat rows with no matching entries as errors." even though the biml file is explicitly telling it to send them to the no match output.
<Lookup Name="Correlate" OleDbConnectionName="SSISIncrementalLoad_Dest" NoMatchBehavior="RedirectRowsToNoMatchOutput">
Executive Junior Cowboy Developer, Esq.[/url]