This transform has the potential to replace stock SCD transform, and offers some nice features of it's own. A brief description cribbed from the author's site-

One question that arises very often in Data Warehouse programming is “what are the differences between these two tables/flows of data?”. It is often the case in SCD management, you receive several millions of customers and should decide what changes need to be done after your last successful load.

Using SSIS we have the SCD component, it works but it works so slow that in the production environment it is quite always convenient to create an “ad hoc” solution to handle the SCD.

We decided to write an SSIS component that has two inputs, one for the “old” and one for the “new” data, compares all the rows that come in from the old and the new flow and sends them to different outputs, namely:

• unchanged rows (are the same in both input)
• deleted rows (appear in old but not in new)
• new rows (appear in new but not in old)
• updated rows (appear in both but something is changed)

For more information see the full article at http://www.sqlbi.eu/Projects/TableDifference/tabid/74/Default.aspx

.