title: CodePage error while importing data from Oracle to SQL Server using SSIS
body: <p>I get the following warning on the OLEDB Source in the SSIS package.</p>
  
  <blockquote>
    <p>Warning   1   Validation warning. Data Flow Task:
    {20582F6F-DD9C-45F5-8727-992F525E67DC}: Cannot retrieve the column
    code page info from the OLE DB provider.  If the component supports
    the "DefaultCodePage" property, the code page from that property will
    be used.  Change the value of the property if the current string code
    page values are incorrect.  If the component does not support the
    property, the code page from the component's locale ID will be used. </p>
  </blockquote>
  
  <p>After setting the AlwaysUseDefaultCoePage to true the warning disappears but 0 rows are transferred from source to destination. There is also no error shown.</p>
  
  <p><strong>Update:</strong> The oracle server uses the <strong>US7ASCII</strong> character set. I am unable to find the code page number for this character set.</p>