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 flow with SSIS.
Its main advantage over 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 TableDifference component is now part of CozyRoc SSIS+ 1.4 library and can be downloaded from the following link: http://www.cozyroc.com/products
All support and enhancement questions should be addressed with the CozyRoc team.
Important notes to 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 (first version of TableDifference has been released in 2006) we have seen a large adoption of TableDifference and many companies requested us fixes and support. SQLBI is a consulting company and is not structured to provide full support services for SSIS components. Thus, we moved full rights on source code to CozyRoc, which is a company focused only on developing and supporting SSIS components. They will be able to give a full support to companies using TableDifference in a production environment, and this is something that several customers asked us in the past.
If your company is already using an old 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 and to a broader set of SSIS components.