SCD Merge Wizard
SCD Merge Wizard helps generate merge scripts for Slowly Changing Dims
SCD Merge Wizard will help you generate T-SQL script for merging two tables into one which can be used to replace Microsoft's Slowly Changing Dimension SSIS Component which is proven to be very slow in cases of tables with large number of columns and/or records.