This project has moved. For the latest updates, please go here.

Multiple Hash

Feb 4, 2010 at 10:22 AM

Hi!

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!

 

 

Coordinator
Feb 6, 2010 at 12:51 AM

who2506,

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 11:05 AM
Edited Feb 16, 2010 at 9:19 AM

Hi!

 

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