Tuesday, August 11, 2009

SSIS: OleDB Data source: cannot retrieve the column code page info from the OLE DB provider


When i tried to set a DB2 data source in a SSIS package, the following warning was shown when the clicked preview button.

Warning at {Local Component ID} [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.

To resolve, Under properties -> Custom Properties -> set AlwaysUseDefaultCodePage : True

Resource: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/bb08af3a-5080-40d0-b00b-e278115cb2ad


1 comment:

Anonymous said...

Mohammed, I had the same problems and have been searching for solution for several hours. I came across some solutions that were more diffcult than the problem, and did not work. I was lucky to find your solution that was short and to-the-point, and more important, it works.
Thank you,