You need to take care of two things while using Merge Join in SSIS :

1) Is Sorted is set to "True" and Sort Key is defined on the sort column

2) The data set (in the source query) needs to be actually sorted on the Sort Key column above.

Only then you will be able to get correct results.

Hope this helps .. 🙂