title: SSIS - Flat file always ANSI never UTF-8 encoded
body: <p>Have a pretty straight forward SSIS package:</p>
  
  <ul>
  <li>OLE DB Source to get data via a view,  (all string columns in db table nvarchar or nchar).</li>
  <li>Derived Column to format existing date and add it on to the dataset, (data type DT_WSTR).</li>
  <li>Multicast task to split the dataset between:
  <ul>
  <li>OLE DB Command to update rows as "processed". </li>
  <li>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.</li>
  </ul></li>
  </ul>
  
  <p>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.</p>
  
  <p>Am I doing something wrong - how can I get the flat file to be UTF-8 encoded?</p>
  
  <p>Thanks</p>