SSIS: Connect to Oracle - Cannot retrieve the column code page info from the OLE DB Provider
I have tried to access data in Oracle from SSIS via OLE DB and the component reported the following warnings:
"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."
The fix is simple. Set AlwaysUseDefaultCodePage=TRUE on the offending OLE DB Source component and it works fine.
Monday, May 20, 2013
SSIS: Connect to Oracle - Cannot retrieve the column code page info from the OLE DB Provider
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment