• 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