Skip to main content

Use Custom Components

Determines if BimlFlex uses the SSIS Custom Components to log RowCounts and generate Hash Keys. Set this to N if deploying to Amazon RDS.

This setting applies to SSIS output. When disabled, the generated packages do not use the BimlFlex custom components; hash keys are instead derived in SQL when the project uses Pushdown Processing, and the staging tables' hash columns are created nullable so the SQL load can populate them.

When to Change This Setting​

Keep the default Y for SSIS projects on servers where the BimlFlex custom components can be installed. Set it to N for environments that do not allow custom SSIS components, such as Amazon RDS, and pair it with Pushdown Processing so hashes are computed in SQL.

SettingInteraction
Hash AlgorithmThe algorithm used for the hash keys the components generate
Use SQL Compatible HashKeeps SSIS-computed and SQL-computed hash values aligned

Notes​

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