SSIS: Using a checksum to determine if a row has changed
I just read an interesting article that helps me simplify my incremental load packages by using a checksum of the processed row to determine if the underlying data has changed. While scanning through the comments of the article, I realised that using the simple checksum component recommended in the article could eventually lead to missing a data change. Luckily there is a advanced hashing component available, supporting MD5 and SHA1 hashes.
