Have you ever had the need to create a row hash in an SSIS Data flow? No? Why would I ever need to do that? What’s a row hash, anyway? Well, Bob Blackburn gives a nice demo that answers all these questions here.
So this post is to add on to that topic. Suppose that you have some transformations or lookups that were performed in the data flow and you want to hash the end result set of columns before you determine what has changed. So the steps would be:
- Add a script component to the data flow
- Add a column to the output called Row_Hash
- Add the following into the script component: