SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus
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.
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About Marco Russo (SQLBI)
Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.