Convert Date To String With Scale
Used to control the converted DateTime in the FlexToBk to ensure compatibility with the SQL code.
When enabled (the default), DateTime and DateTime2 columns that participate in an Integration Key (FlexToBk) expression are cast to a timestamp with explicit scale in the generated SSIS expression — DT_DBTIMESTAMP2 with the column's scale, or scale 3 for DateTime and low-scale DateTime2 columns — before being converted to text. This keeps the fractional seconds in the key string consistent with the equivalent SQL-side conversion. When disabled, the cast is omitted from the generated expression.
When to Change This Setting
Keep the default Y so Integration Keys built from datetime columns produce the same string in SSIS data flows as in SQL-based loads. Only disable it when key values must match an existing convention that was built without the scale conversion.
Related Settings
| Setting | Interaction |
|---|---|
| Use Compatable Date Format | The SQL-side counterpart, aligning SQL date-to-string conversion with SSIS |
| SSIS Hash Null Value Replacement | The null replacement used in the same generated key expressions |
Notes
- This setting is part of the SSIS settings category.
- The default value for this setting is
Y.