This is a short example tutorial on the lookup transform object in SSIS. The Lookup is used to match or no match records with a destination and route the source records through the related path.
We also try matching multiple columns to demonstrate the Lookup can match using more than 1 column.
https://www.dbtales.com