In SSIS, why Merge Join creates rows with all NULL value?
I'm trying to use a Merge Join component to do a Full Outer Join on two data sets. However after the Merge Join task is done, there are rows with all NULL values. Why this happens and how can I fix it? Thanks.