kh (12/30/2008)
I find this related article very interesting:http://blogs.msdn.com/mattm/archive/2008/11/25/lookup-pattern-range-lookups.aspx
It describes the performace differences from Lookup, Merge, and Script Component used to solve the same logic. Very cool reference.
Indeed a good reference. I am surprised that I never came across it while googling around for SSIS lookup.
Regards,
Sachin Dedhia