Hi All, Today I would like to tell you the required settings to be done for using Merge Join in SSIS. Merging the data from 2 different sources can be implemented in various ways. And that depends on many things like both sources are on same SQL server or on different SQL servers but available as linked server or one source is MS SQL Server and other is Oracle etc. But apart from all these, you concentrate on mainly 2 things, which will quickly get your job done. We know basic requirements of using “Merge Join” data flow component. Both … Continue reading →