Error: Cannot retrieve the column code page info from the OLE DB provider.


Error: [OLE DB Source [1]] Warning: 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.

Description: This is actually a warning not an error by OLE DB. This warning occurs in SSIS project while we do a data transfer from source (Oracle) to destination SQL Server via OLE DB. This is because for the Oracle database the default code page is missing due to this it leads to bad data conversions. SSIS supports the option of specifying a per-column Locale Identifier for string data types, such as CHARACTER. However, the OLE DB Provider for Oracle does not support this option.

Solution: We can overcome this OLE DB warning by changing the property of OLE DB Source Data Flow Component. That property is AlwaysUseDefaultCodePage, by default the value is False, change it to True. Rebuild the project.

Advertisements