Monthly Archives: August 2011

SSIS Merge Join Transformation vs Lookup Transformation

S# Merge Join Lookup 1 Partially Blocking(synchronous) Row Based (synchronous) 2 Two inputs One input. 3 One output Three Outputs: Lookup   match output No Match output Error output 4 No error output available Error output available. No restriction on data sources. The Lookup transformation … Continue reading

Posted in SSIS | 3 Comments