title: SSIS (ASCII needed): "Code page is 1252 and is required to be 20127"
body: <p>I have a requirement to export a database to a tab-delimited file in the ASCII format. I am using derived columns to convert any Unicode strings to non-Unicode strings. For example, a former Unicode text stream is now casted as this:</p>
  
  <pre><code>(DT_TEXT,20127)incomingMessage
  </code></pre>
  
  <p>But SSIS is still looking for ANSI. I am still seeing an error at the Flat File Destination:</p>
  
  <pre><code>The code page on input column &lt;column_name&gt; is 1252 and is required to be 20127.
  </code></pre>
  
  <p>This happens for <strong>any</strong> column in the table, not just Unicode ones.</p>
  
  <p>This is what I have been doing to ensure ASCII is used:</p>
  
  <ul>
  <li>In the Flat File Connection Manager, used Code page "20127 (US-ASCII)"</li>
  <li>Used a Derived Column to cast data types</li>
  <li>In the OLE DB source, set the default code page to 20127</li>
  </ul>
  
  <p>Any thoughts?</p>