External File Conversion
By default, the extraction process from a source to Blob Storage applies several conversions to create files that are supported by the target storage type. This setting allows control of this conversion process. This setting only applies for Azure Data Factory integration templates.
When enabled, string columns loaded from staged files are translated back as part of the staging load SQL: the placeholder control characters written during extraction (CHAR(26), CHAR(29), CHAR(30)) are converted back to line feed, carriage return, and the | delimiter. When disabled, the staged file content is loaded as-is.
When to Change This Setting
Keep the default Y when BimlFlex performs the extraction, so values containing line breaks or delimiter characters survive the round trip through the staged files. Disable it when the staged files are produced by a process that does not apply these conversions.
Related Settings
| Setting | Interaction |
|---|---|
| External File Format | The external table definition used to read the staged files |
Notes
- This setting is part of the Azure settings category.
- The default value for this setting is
Y.