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

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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
Commented:
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.

Author

Commented:
Thanks.

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