title: How to export Japanese characters from SQL Server 2008 database to a text file?
body: <p>I have an odd problem. I need to export Japanese characters from a table to a raw text file.  When I run the select statement in SQL, I am able to see the characters displayed correctly.  However, when I run the SSIS package to export these values to a text file they are displayed as <strong><code>?</code></strong>'s.  </p>
  
  <p>Data type of the field is <em>NTEXT</em>. Has anyone ran into this problem before?</p>
  
  <p><em>SQL statement</em>: </p>
  
  <pre><code>select cast(body as nvarchar(max)) as body from msgsMarket
  </code></pre>
  
  <p>In SSIS package's flat file connection manager, I have set the output encoding to use <strong><code>932</code></strong></p>