SSIS Hash Null Value Replacement
The Null value replacement to be used when hashing using the Varigence BimlFlex SSIS Custom component.
Provides backwards compatibility when set to an empty string. For new implementations and SQL hash compatibility, set to the same value as used for HashNullValue.
When to Change This Setting
This value is substituted for NULL columns before hashing, ensuring NULLs produce a deterministic hash. Both this setting and Hash Null Value must match — if they differ, the same source row will produce different hashes in SSIS vs. SQL, causing false change detection. For new projects, set this to the same value as Hash Null Value (default: NVL). Leave as an empty string only when preserving backward compatibility with an existing SSIS implementation that was built before this alignment was introduced.
Related Settings
| Setting | Interaction |
|---|---|
| Hash Null Value | The equivalent NULL replacement used when hashing in SQL. Must match this setting to ensure consistent hash results between SSIS and SQL-based hashing |
| Use SQL Compatible Hash | For SSIS hashes to match SQL HASHBYTES() output, both the SQL-compatibility mode and the NULL replacement value must be aligned across SSIS and SQL |
| Hash Algorithm | Defines the algorithm applied after NULL substitution. The NULL replacement value is part of the pre-hash input and must be consistent regardless of algorithm chosen |
Notes
- This setting is part of the Core settings category.