More SSIS tutorials at http://www.analyticsinaction.com/category/data-integration/. Demonstration on how to construct a Merge Join transformation using SQL Server Integration Services (SSIS). The demonstration also includes a fix to avoid issues with "White Space" around join keys.
I sense a bit of Kiwi accent there :)
jamesjiao 10 months ago
Cant wait for your other videos on exporting the results to flat or sql files.
TY :)
vasavi1011 2 years ago
Hi, TY once again for the SSIS videos. they are quite informative and helpful. I am currently working on merging of various source file to a masterfile (csv) and after seeing your videos. it looks that it should be done w/o any hassle. but
I was wondering that can we transpose data as I have a excel files and the row/columns exchange in the master file. If you can please guide me and appreciate your if there can be a video on that.
vasavi1011 2 years ago