Friday, September 11, 2009

How to resolve data flow warnning from Oracle to MSSQL

Sympton:


Warning at {56AA1808-8DC8-44FC-9946-7076F50D9CCE} [OLE DB Source [1]]: 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.



Warning: 0x80202066 at Data Flow Task, OLE DB Source [1]: 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.


Solution:

Set "AlwaysUseDefaultCodePage" to true.





2 comments:

  1. Y si no uso SSIS? estoy usando el asistente para exportar datos de SQL Server 2008.
    En todos lados encuentro que es por SSIS pero no lo tengo instalado!!!!

    ReplyDelete
  2. I think this is a very nice and informative blog post about SQL,SSIS and many other related utilities.

    SSIS Postgresql Read

    ReplyDelete