SSIS - Flat file always ANSI never UTF-8 encoded

Question

Have a pretty straight forward SSIS package:

• OLE DB Source to get data via a view, (all string columns in db table nvarchar or nchar).
• Derived Column to format existing date and add it on to the dataset, (data type DT_WSTR).
• Multicast task to split the dataset between:
  • OLE DB Command to update rows as "processed".
  • Flat file destination - the connection manager of which is set to Code Page 65001 UTF-8 and Unicode is unchecked. All string columns map to DT_WSTR.

Everytime I run this package an open the flat file in Notepad++ its ANSI, never UTF-8. If I check the Unicode option, the file is UCS-2 Little Endian.

Am I doing something wrong - how can I get the flat file to be UTF-8 encoded?

Thanks

Answer 1

OK - seemed to have found an acceptable work-around on SQL Server Forums. Essentially I had to create two UTF-8 template files, use a File Task to copy them to my destination then make sure I was appending data rather than overwriting.