It's quite common to have a requirement to generate a SHA1 or MD5 Hash in SSIS to help with comparing non-key columns for “delta” management. One question that comes up is “What’s the fastest way to generate a Hash”. I just did a little test to compare two methods: Method a) SQL Servers HashBytes(‘SHA1’, Column1+ … Continue reading How to Generate a Hash in SSIS