title: SSIS : How to process a UTF-8 file which has no Byte Order Mark?
body: <p>I'm using a Flat File Connection to read a file. This file contains UTF-8 data, but the file does not have a Byte Order Mark. (I checked this with notepad++)</p>
  
  <p>The CodePage from the flat file connection is set to '65001' and UniCode is set to 'False'.</p>
  
  <p>While processing this file and copying the data to the database, some characters are wrong.</p>
  
  <p>What is the best/easiest solution ?</p>
  
  <ol>
  <li>Change some settings on the flat file connection ? (This will
  probably also mean that I need to change the codepage from the
  columns.)</li>
  <li>Manually add the Byte Order Mark to the file before processing?</li>
  <li>Something else ?</li>
  </ol>