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).
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]”