I have two tables for example Employee and Department ,If i inner join these two tables on department Id i am getting 13 rows which is correct.
To get the same results using SSIS i am using two OLE DB Source and a Merge join Transformation by setting the IsSorted Property to true and the setting the SOrtKey Position to 1 i am getting around 4 rows but instaed of setting this IsSorted Property to
true if i use the SORT Tranfoamtion before Merge Join I am getting the Proper result.
So my question is that ,Is their is any difference between ths SORT Tranformation and IsSorted Property ??
Regards, Santhosh Hiriyanna
View Complete Post