The new and improved SCD handling with SSIS

Thanks to Alberto Ferrari there is a new way to handle Slowly Changing Dimensions (SCD) with Integration Services: he just released Table Difference 1.1 and FlowSync 1.0. Both are downloadable at www.sqlbi.eu.

The problem that those components solve is lack of performance handling large dimensions. Standard SCD component is very slow.

The FlowSync component is also interesting to solve nasty memory problems occurring when you have many asynchronous transformation into a the same Data Flow Task and a lot of data to process.

I’d like that SSIS dev team take a look at those components for the next version of SQL Server.