can someone please guide me regarding the difference between MERGE and MERGE JOIN TRANSFORMATIONRegards, Amitesh Srivastva

Merge Join is same as JOIN in t-sql, you can choose between different types of Inner join, left outer join and outer join the difference is that with Merge join transformation you can support two inputs from two different data source, for example one from flat file and another from oracle DB, but with join in t-sql you can only join from one data source. Merge Transform is not actually like join, this will merge rows like UNION. this differ from UNION ALL Transform a bit, you can see difference between merge and union transforms here: http://sqlserversolutions.blogspot.com/2009/01/difference-between-merge-and-union-all.htmlhttp://www.rad.pasfu.com

The Merge transformation is similar to the Union All transformations. The Merge Join Transformation joins two data sets on a common key (or keys) Please check the similar thread . Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

many thanks Reza , its really very helpful to me Regards, Amitesh Srivastva

Merge Act like a union all in T-sql but you can provide only two input to this transformation which must be pre sorted and merge join joins the two datasets like T-SQL joins(inner join , left join,right join )

Why Right outer join is not available in Merge join transformation.Is there any specific reason behind this. Regards, Sunny sunny

Hi, Check this below article on the Merge Joins in SSIS http://beyondrelational.com/blogs/sherryli/archive/2011/08/22/ssis-97-when-merge-join-is-your-friend.aspx Thanks Karthikeyan Anbarasan www.f5debug.net Free Ebook on SSIS Tutorial - Download here SSIS Step by Step

Also check these articles on Merge and Merge Join Transformations http://f5debug.net/2011/04/25/sql-server-integration-services-ssis-%E2%80%93-part-50-%E2%80%93-merge-transformation-in-ssis/ http://f5debug.net/2011/04/27/sql-server-integration-services-ssis-%E2%80%93-part-52-%E2%80%93-merge-join-transformation-in-ssis/Thanks Karthikeyan Anbarasan www.f5debug.net Free Ebook on SSIS Tutorial - Download here SSIS Step by Step