Categories
Sql Server

Cannot retrieve the column code page info from the OLEDB provider

Cannot retrieve the column code page info from the OLEDB provider

Hi friends, recently I am working on SSIS package, in which we have to fetch data from SQL Server and send that data to oracle. But i am getting an error: Cannot retrieve the column code page info from the OLEDB 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 supports the property, the code page from the component locale ID will be used.

Cannot retrieve the column code page info from the OLEDB provider

Solution:

On the DataFlow task, open the Advanced Editor, select the Component Properties tab and in the Custom Properties section set the AlwaysUseDefaultCodePage to True.