Hash Null Value Replacement
The Null value replacement to be used when hashing.
When to Change This Setting
This value is substituted for NULL columns before hashing, ensuring NULLs produce a deterministic hash. Both this setting and SSIS Hash Null Value must match — if they differ, the same source row will produce different hashes in SSIS vs. SQL, causing false change detection. Only change this value if you have a specific reason to use a different NULL sentinel (for example, a source system that already uses NVL as a data value). When changing, update SSIS Hash Null Value to the same value at the same time.
Related Settings
| Setting | Interaction |
|---|---|
| SSIS Hash Null Value | The equivalent NULL replacement used when hashing in SSIS. Must match this setting to ensure consistent hash results between SQL-based and SSIS-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.
- The default value for this setting is
NVL.