Showing posts with label DefaultCodePage. Show all posts
Showing posts with label DefaultCodePage. Show all posts

Tuesday, August 11, 2009

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

Hi,

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.

Solution:
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

Regards
Fauzi