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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics