Today I come into a nice bug (misfeature?) of SSIS 2008 and I'd like to share it with you. Let's start from the beginning: One of the keys to make something speedy is to parallelize it. In TableDifference I read from two inputs, compare them and produce several outputs for new, deleted, updated rows and so on. It is the classical ...

TableDifference has been updated to version 1.1. The major improvement is the fact that now TableDifference can handle a field as Key: a field that represent a key in the table, you must supply KeyOrder Compare: a field that is to be compared between OLD and NEW, you must supply UpdateID PreferNEW: the field appear in both flows but you ...

In SSIS the SCD component does a lot of work for you but it works so slowly that it is quite always convenient to create an “ad hoc” solution to handle the slowly changing dimensions. As the main problem is that of determining the difference between the last snapshot of the SCD and the current data we decided to write an SSIS component ...