I am currently using Merge Join to perform an inner join on two sorted sets of data in SSIS. The problem I am having is that no records are being returned from the inner join. To troubleshoot I have performed the following:
1) I exported both sorted data sets into my local SQL server, and wrote an inner join manually. This confirmed that I should be receiving 720 rows as a result of the inner join between the two data sets.
2) I used a lookup, instead of a merge join, to perform the inner join and this actually worked. The reason I do not want to use a lookup is because of the performance I am getting with these sets of data. To give you an idea of the data I'm working with, table A has ~16k rows and table B has ~7.8 million rows. Using the lookup component yielded a run time of over an hour.
So I was wondering if you guys could help me get the Merge Join setup correctly. To help you help me, I've provided screen shots of how I currently have things configured:
(Sorry I couldn't post the full hyperlinks, stack overflow doesn't let new users post more than 2 links)
Data Flow of Job: http://i44.tinypic.com/5xvp4z.jpg
Table A Sort: http://i40.tinypic.com/99ie4h.jpg
Table B Sort: http://i41.tinypic.com/2hdqz5t.jpg
Merge Join: http://i39.tinypic.com/xlh3s2.jpg
If there is any more information I could provide that would be helpful, please let me know!