Hi All, I have a question regarding joining of two tables which are present in two different servers (In oracle Database) My source is Oracle and my destination is sql server....Need to join 2 oracle tables present in different servers through SSIS Package... Can anyone help me in this regard..? Appreciate ur help.. Thanks, vineesh1701

you can use Merge Join Transformation , Note that you should SORT inputs before connect it to merge join. you can sort data sources with Order by clause on each source, and then set IsSorted Property for output to true, and set SortKeyPosition for sorted columns OR use SORT Transformation to sort each sourcehttp://www.rad.pasfu.com

Reza is correct, for your reference ... check this thread also. Let us TRY this | My Blog :: http://quest4gen.blogspot.com/