Very Good Article. I have a question. Suppose you have a dimension that contains certain columns that are type 2 where you want to keep track of historical changes. However,...

I found an easier way using steps in this MS KB article on the very same subject. I tried it and it works very well.

Solution : Set ConnectionString property of...

I have been a BI Professional at some large and small companies over the past 11 years. I have worked with many BI tools, primarily Cognos, over this period. My...

The Slowly Changing Dimension task in SSIS will do exactly what you want to. You can set this up to do both updates and inserts. It will ignore records that have no...