In SSIS, why Merge Join creates rows with all NULL value?

thomaszhwang used Ask the Experts™
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.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
That happens due to the Outer Join and you could fix that by writing your own select if possible to include the outer join and use ISNULL or build a CASE for NULL values.



Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial