Skip to main content

Use SQL Compatible Row Hash

Determines if the SSIS custom inline hashing component for Full Row Hashing use a hashing approach compatible with the SQL Server HASHBYTES() function.

The default is false for backward compatibility however we recommend setting this to true for new projects to make it forward compatible with cloud deployments.

When to Change This Setting​

The default is false for backward compatibility with existing projects. For new projects, set to true so that row change detection hashes are forward-compatible with cloud deployments where SQL HASHBYTES() is used. Enabling this setting ensures that full-row hashes generated by SSIS match what would be produced by SQL Server, which is important when migrating workloads from SSIS to ADF or Databricks — both of which always use SQL-compatible hashing.

SettingInteraction
Use SQL Compatible HashThe equivalent setting for key hashes (hub surrogate keys). Both settings should be enabled together for fully consistent hashing across SSIS and SQL environments
Hash AlgorithmDefines which algorithm is applied. The SQL-compatible row hash uses this algorithm via HASHBYTES() semantics, matching the behavior of Use SQL Compatible Hash

Notes​

  • This setting is part of the Core settings category.
  • The default value for this setting is N.