This project has moved and is read-only. For the latest updates, please go here.

Multiple Hash

Feb 4, 2010 at 11:22 AM


First of all many thanks for creating the Multiple Hash Data Flow Transformation.

I compare the MSSQL function HashBytes('MD5 ',Col1 + Col2) whith the result of the Multiple Hash component for these two columns.

I did not found a possibility to calculate the same result using this approach.

Is there a solution to calculate the same MD5 checksum with the HashBytes function as with the Multiple Hash component?

Thanks in advance!



Feb 6, 2010 at 1:51 AM


Can you please confirm that the following generates the same Hash between SQL Server and Multiple Hash in your environment?

HashBytes('MD5 ',CAST(Col1 + Col2 AS varchar(max)))


It looks like a Unicode handling difference between SQL Server's data being passed to HashBytes, and the way Multiple Hash deals with Unicode.


Marked as answer by kmartin on 7/8/2014 at 6:38 AM
Feb 8, 2010 at 12:05 PM
Edited Feb 16, 2010 at 10:19 AM



Many thanks for your fast reply. It works like expected!