• Great article, Brett. I have a half completed one in my pipe similar to this - but directed solely at how to use a hash to speed up my SCD component - because I think it should!

    For those that are interested in doing this, but aren't comfortable with coding, you can use the Konesans Checksum, or you can use the Multiple Hash component on CodePlex that offers several different hashing methods - see the SSIS Community Tasks and Components site for those extensions.

    Todd McDermid - SQL Server MVP, MCSD.Net, MCTS (SQL08BI)
    Find great SSIS extensions - most are open source - at SSIS Community Tasks and Components[/url]
    Are you doing Data Warehouse ETL with SSIS? Don't use the slow SCD Wizard, use the Kimball Method SCD component instead.