iSven

Unwichtiges nach Relevanz sortieren...

Correct settings for importing Unicode files with SSIS

Just a reminder post for the correct settings to import Unicode files with SSIS:

In the general settings of the “Flat File Connection Manager Editor” select the code page “65001 (UTF-8)” and the Locale “Germany” (or whatever applies to you).

SSIS-Import-Unicode1

In the advanced settings choose the columns, that contain Unicode characters. In my case I have only some columns containing Unicode data. The standard string DataType is “string [DT_STR]. For Unicode choose “Unicode string [DT_WSTR]”

SSIS-Import-Unicode2

Comments are closed