title: SSIS (VS2008) with Oracle OLE DB Source
body: <p>I have a strange problem where in the DEV environment everything is fine but in PROD SSIS reports an error about conversion from unicode to non-unicode. This error happens at the OLE DB Source task level. So, I don't even get the chance to use Derived Columns to perform the conversion.</p>
  
  <p>We installed BIDS on the production server and the task is flagged as in error. When I try to open the properties, it tells me that the metadata is different from what is in the DTSX file. When I accept the offer to automatically correct, all faulty columns input type (External and output columns) have their type switch from <code>DT_WSTR</code> to <code>DT_STR</code>.</p>
  
  <p>The descriptions of the tables involved are identical in DEV and PROD (same types for the columns). If I query for the character sets they are identical in both environment.</p>
  
  <p>For your information, here is the query:</p>
  
  <pre><code>SELECT * 
  FROM v$nls_parameters 
  where parameter 
         like '%CHARACTERSET'
  </code></pre>
  
  <p>which returns:</p>
  
  <pre><code>NLS_CHARACTERSET                   WE8MSWIN1252
  NLS_NCHAR_CHARACTERSET             AL16UTF16
  </code></pre>
  
  <p>on both environment.</p>
  
  <p>Any idea to solve this ?</p>
  
  <p>Thank you,
  Michel</p>