I have a UTF-8 encoded comma delimited file. If I try to load that into a
table using an OLE DB Destination. It goes in as Code page 1252 regardless.
Steps to reproduce the behavior.
1. Create a new SSIS package
2. Create a new Data Flow
3. Create a new Flat File Source
4. Modify the Flat File Source to use Comma delimited file that is encoded
UTF-8 65001. Set the Code Page to UTF-8 65001.
5. Create a new SQL Destination
6. Modify the SQL Destination's as follows.
Set Default Code Page = 65001
Set the AlwaysUseDefaultCodePage = True
7. Run the SSIS Package verify that the table is loaded as Code page 1252
instead of UTF-8 Code Page 65001.
Is this a known bug or something miss configured? Also, if I create a
custom script task I can load the table with the proper code page, UTF-8.
Thanks in advance.