SHA1 ScriptComponent using Metadata

Peter Avenant

I use this as an alternative when I cannot use Custom Components or if I need a Hash column for a source where I cannot use T-SQL Hashbytes. This has worked in all my scenarios, but please test it prior to use. I also hook it up to an external metadata repository, but reading from AdventureWorks should allow you to easily replicate it.