Skip to main content

Use TRY_CAST Conversion

Determines if the select-to-stage tables use TRY_CAST and TRY_CONVERT.

When enabled, the generated select-to-stage SQL uses TRY_CAST and TRY_CONVERT in place of CAST and CONVERT for the data type conversions applied to source columns. TRY_CAST and TRY_CONVERT return NULL when a value cannot be converted, so rows with unconvertible values load with a NULL in the affected column instead of failing the statement.

When to Change This Setting​

Keep the default N so that unexpected, unconvertible source values fail the load and surface as errors. Enable it when the source is known to contain occasional malformed values that should not stop the load, accepting that those values arrive as NULL.

SettingInteraction
Apply Data Type MappingsControls whether the expanded data types that drive these conversions are applied to the Staging layer

Notes​

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