The Merge Join Transform in SSIS is a great way to load a Data
warehouse quickly and an easy way to join two data sources
together. There are a few requirements to join these two data
sources. The data sources must be sorted and there must be a key
that you can join them with. This can all be done in the data
flow of the SSIS package. Here are some examples of a Merge Join
with some different situations so you can see the outputs. The
two images below show two tables. The first table contains the
first names of people and the second table contains there last
names. Each table contains an ID column that will be used in the
join. These are OLEDB sources. The queries in the sources are
calling the data and sorting it with an order by clause. The
source does not know the data is sorted so you have to manually
tell the source it is sorted. You do this by right clicking on
the source and selecting Show Advanced Editor. Then click on the
Input Output Properties Tab. Click on the OLE DB Source Output
and Set the IsSo