title: SSIS: Code page goes back to 65001
body: <p>In an SSIS package that I'm writing, I have a CSV file as a source. On the Connection Manager General page, it has <code>65001</code> as the Code page (I was testing something). Unicode is not checked.</p>
  
  <p>The columns map to a SQL Server destination table with <code>varchar</code> (among others) columns. </p>
  
  <blockquote>
    <p>There's an error at the destination: The column "columnname" cannot be processed because more than one code page (65001 and 1252) are specified for it.</p>
  </blockquote>
  
  <p>My SQL columns have to be <code>varchar</code>, not <code>nvarchar</code> due to other applications that use it.</p>
  
  <p>On the Connection Manager General page I then change the Code page to <code>1252 (ANSI - Latin I)</code> and OK out, but when I open it again it's back to <code>65001</code>. It doesn't make a difference if (just for test) I check Unicode or not.</p>
  
  <p>As a note, all this started happening after the CSV file and the SQL table had columns added and removed (users, you know.) Before that, I had no issues whatsoever. Yes, I refreshed the OLE DB destination in the Advanced Editor.</p>
  
  <p>This is SQL Server 2012 and whichever version of BIDS and SSIS come with it.</p>