TableDifference is an SSIS custom component designed to simplify the management of slowly-changing dimensions and – in general – to check the differences between two tables or data flows with SSIS.
Its main advantage over the Microsoft standard SCD component is its speed and ease of use. The component receives input from two sorted sources and generates different outputs for unchanged, new, deleted, or updated rows.
Now available from CozyRoc!
As of January 1, 2010 the TableDifference component is now part of the CozyRoc SSIS+ 1.4 library and can be downloaded at the following link: http://www.cozyroc.com/products
All support and enhancement questions should be addressed to the CozyRoc team.
Important notes for TableDifference users
Users who downloaded TableDifference until December 31, 2009 are using a freeware project with full source code. Thus, they can continue using this component without any issue.
Starting from January 1, 2010 the TableDifference component is no longer available from SQLBI. In the last 4 years – the first version of TableDifference was released in 2006 – we have seen a large adoption of TableDifference and many companies requested fixes and support from us. SQLBI is a consulting company and is not structured to provide full support services for SSIS components. Thus, we moved the full rights over the source code to CozyRoc, which is a company focused strictly on developing and supporting SSIS components. They will be able to provide full support to companies using FlowSync in a production environment, and this is something that several customers had asked from us in the past.
If your company is already using an older, free version of TableDifference, you can continue to use it for free. However, moving to the new CozyRoc version will grant you access to full support services and to a broader set of SSIS components.