Use SQL Compatible Hash
Determines if the SSIS custom inline hashing component use a hashing approach compatible with the SQL Server HASHBYTES() function.
This is recommended so that the hashed values can be recreated using standard SQL queries when needed.
When to Change This Setting
Enable (Y, the default) so that hash values produced in SSIS Data Flows match those produced by SQL Server HASHBYTES(). This is critical if you ever need to verify or recreate hashes using SQL queries — which is common during data reconciliation and debugging. Disabling this setting means SSIS-generated hashes will differ from SQL-generated hashes for the same input, making reconciliation between the two environments unreliable.
Note: This setting only applies to SSIS projects. ADF and Databricks projects always use SQL-compatible hashing.
Related Settings
| Setting | Interaction |
|---|---|
| Hash Algorithm | Defines which algorithm is used. The SQL-compatible hashing mode applies that same algorithm via HASHBYTES() semantics |
| Hash Binary | Controls whether the hash is stored as binary or string. Ensure this is consistent when comparing SSIS hashes with SQL HASHBYTES() output |
| Use SQL Compatible Row Hash | The equivalent setting for full-row change detection hashes. Both settings should be aligned for consistent behavior across key and row hashing |
Notes
- This setting is part of the Core settings category.
- The default value for this setting is
Y.