Merge join or Lookup which is cost affective in ssis

Question

I need to join 2 tables with more than 20 million reocrds.Which of the below mentioned solution is good

    1 one Oledb componet and a lookup component 

or

 2 Two oldeb componets,2 sort componets and a merge join componets

Answer 1

depends among other things on how many bytes from the look up table you need. If you go for merge join it probably is a good idea to read the by sql ordering by key and then connect directly to the merge join transformation.

Answer 2

When there are many records, the lookup option is better: it gives better performance because it is a synchronous transformation.