August 10, 2010 at 6:50 am
I am having issues with an SSIS package that connects to an Oracle database with the following error: "Cannot retrieve the column code page info from the OLE DB provider."
This is a very simple SSIS package and it even causes issues with the package hanging and/or failing.
The full warning is:
SSIS package "MyPackage.dtsx" starting.
Information: 0x4004300A at Load to Staging, DTS.Pipeline: Validation phase is beginning.
Warning: 0x80202066 at Load to Staging, OLE DB Destination [332]: 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.
Any help is appreciated.
August 10, 2010 at 8:35 am
This is a warning message which means that the data provider that is under use does not publish code pages used for text columns. Please ensure that the values assigned by default are correct.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 11, 2010 at 5:57 am
Do you mean the datatypes?
August 11, 2010 at 10:18 am
Yes the datatypes. Also found this information. You may try the workaround.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply