select mr.institution_name, mr.institution_id, mr.oppty_id, mr.start_date, mv.startdate from mr_staging as mr inner join ceb.dbo.MRvw_memmismatch as mv on mr.oppty_id = mv.opptyid where mr.start_date <> mv.startdate
I execute this query and get 80 rows..which is the mismatch data.
That is ok…
Now I try to implement this is ssis
I have two ole db sources, for both tables.then I sort them on the oppty_id
Then I do merge join, then I have a condition split where i give the above condition then I collect the data in aa excel file.
But when I execute the task it does not do the merge join and I have no data in the excel sheet… where am I going wrong.