Hi All, This is Regarding SSIS.... I am merging the data from two oledb sources using a join key by using merge join transformation......... It giving me all NULL Records even though there are matching records between the two sources. When I am executing the same thing using T-sql ...I am getting the results but the same when I am doing with merge join(SSIS) i am getting null records..... I have checked the join key datatypes of the two data sources ...They are of same type....I don't know what I am still missing here....Even I am not getting any clue... Can anybody help me out......of this situation...?vineesh1701

Put in a Data Viewer on both inputs to the Merge Join and verify that all your fields do in fact contain data. Your claim is that the Merge Join componenet does the merge, but the fields get wiped out to NULLs? Are you seeing output records at all?Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

Thanks for immediate response Before Merge join I am able to see the Records...But after Merge join all the records are coming as NULL. (Included the dataviewers before and after merge join) vineesh1701

Before applying the merge join sort the records in both the OLEDB Data Sources. May be that might be the problem. If this post is solving your problem please mark it as answered

Did that too.....But Still not working...:((vineesh1701

Hi vineesh1701, I am having the same problem . Did you find the reason?