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

Hashes returning NULL

Aug 22, 2014 at 8:50 PM
Edited Aug 22, 2014 at 8:52 PM
Environment: Visual Studio 2010 Data Tools/SQL Server 2012 both on the same box, Windows 2008 R2 Enterprise.

I downloaded and installed the latest 64-bit Multiple Hash component, and created my first data flow using the component. However, the hash values are not being generated as expected (all NULL values in the generated hash column).

My first assumption is operator error, although the package builds and runs without error, and the rest of the input columns are populated successfully. I'm building a file-based package. Is there a "safe mode" configuration that would be a good first config to try and then build on?

Aug 22, 2014 at 9:49 PM
OK, it was operator error ... 8^) ...

I failed to notice that the hash input column wasn't connected by default to the output in the OLE DB destination.

Marked as answer by MarkJ001 on 8/22/2014 at 1:49 PM