title: SSIS Package: convert between unicode and non-unicode string data types
body: <p>I am connecting to an Oracle DB and the connection works, but I get the following error for some of the columns:</p>
  
  <pre><code>Description: Column "RESOURCE_NAME" cannot convert between unicode 
  and non-unicode string data types.
  </code></pre>
  
  <p>Value for RESOURCE_NAME:</p>
  
  <ul>
  <li>For Oracle: <code>VARCHAR2(200 BYTE)</code> </li>
  <li>For SQL Server: <code>VARCHAR(200 BYTE)</code></li>
  </ul>
  
  <p>I can connect to the Oracle DB via Oracle SQL Developer without any issues.  Also, I have the SSIS package setting <code>Run64BitRuntime = False</code>.</p>