Hello,

I found this article really interesting. I implemented this approach using SSIS 2012 in slightly different way. Instead of storing the hash value in target table, I have computed it in the package using another script task and compared this hash value with hash value from source. However, the hash values from source and target are not matching even when there is no change in source data. Not sure why this has happened. I verified that input column sequence is same for both script tasks i.e. I have ticked the inputs columns in same order for source and target script tasks.

I have attached screenshot of the package. Any help is appreciated..!! 🙂

Thanks in advance..!!