Use Compatable Date Format
Used to control the converted DateTime in the FlexToBk to ensure compatibility with the SQL code.
When enabled, datetime and datetimeoffset columns in Integration Key (FlexToBk) expressions in the generated SQL are converted with CONVERT(VARCHAR(length), value, 121) (the ODBC canonical format that matches how SSIS renders datetime values as text) instead of the configured FlexToBk date pattern. The same conversion is applied automatically for PSA delta detection loads that run outside pushdown processing, regardless of this setting.
When to Change This Setting
Keep the default N when all loads for a solution are generated with the same processing style. Enable it when SSIS packages and SQL-based (ELT) loads both build Integration Keys from datetime columns, so both produce identical key strings and delta comparisons stay consistent.
Related Settings
| Setting | Interaction |
|---|---|
| Convert Date To String With Scale | The SSIS-side counterpart, aligning SSIS date-to-string conversion with SQL |
Notes
- This setting is part of the SSIS settings category.
- The default value for this setting is
N.