Skip to main content

Use UTF8 Data Conversion

Determines if SSIS Express-based extract packages apply UTF8 data conversion.

This setting only affects batches that use SSIS Express. For extract packages that write flat file exports for Azure Blob Storage or Azure Synapse Analytics targets, enabling it (the default) generates the flat file format as UTF-8 (code page 65001, non-Unicode columns) with matching data conversion in the package; disabling it generates a Unicode flat file format with code page 1252 instead.

When to Change This Setting​

Keep the default Y so exported files are UTF-8 encoded, the encoding the downstream Azure ingestion expects. Disable it only when a consumer of the exported files requires the Unicode/1252 format.

Notes​

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