Merge join in SSIS
how to use merge join in SSIS?
October 22nd, 2010 12:19pm
how to use merge join in SSIS?
http://www.mssqltips.com/tip.asp?tip=1322
This is the first link I got while searching your question. Believe me there is a lot of helpful stuff on internet.Nitesh Rai- Please mark the post as answered if it answers your question
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2010 12:23pm
Thanks nitesh..a good link....
October 22nd, 2010 12:26pm
Nitesh will u please elaborate....When I drag my two oledb sources on merge join, it immediately asks for Merge join left output or Merge join left output. exactly what is the difference.
And also when I see Merge join transformation editor...there is one more dropdown to specify join...........
Thanks....
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2010 12:35pm
the difference is between Right outer join and Left outer join.
for distinguishing between different type of joins look at this link:
http://en.wikipedia.org/wiki/Join_%28SQL%29http://www.rad.pasfu.com
October 22nd, 2010 1:34pm
Hi Rohit,
Merge Join left output and right output is nothing but simple join basics similar to joins in SQL Server.
Please go through the below link which has an example of merge join.
http://www.ssistutorial.com/create_join_between_datasets_in_ssis.php
I hope this helps :)
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2010 2:01pm
Thank you Indu....that is a really nice article...cleared my doubt.
October 22nd, 2010 3:00pm