I noticed this has been posted before - but could not get it working with the information on that post so here goes:
I have a T-Sql query that INNER JOINs 2 tables on one field - this returns 6,383 records.
(the one table contains 6,383 records and the other table 12 records)
However when I try to implement a data flow task with two data sources (one for each table) and sort the and then try to use the Merge Join transformation to sort and join them on the exact same field the result is 11,073 records.
What is going on here? logically this does not make sense to me ...
View Complete Post