Hi everyone,
We're stuck with this. We've got a Db2 source connection and when we try 'Preview' button appears the following error:
TITLE: Microsoft Visual Studio
The component reported the following warnings:
Warning at {420E9420-175B-4C2F-856A-EA5D51C23627} [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.
Choose OK if you want to continue with the operation.
Choose Cancel if you want to stop the operation.
Does anyone have ever used DB2 driver from a dtsx package? If so, let me know if you had any related problem with.
Another day it happens with Oracle.
Thanks in advance for your time,
The DB2 OLE DB provider does expose code page information, so it is warning you of this fact. It also suggests a workaround/fix. The OLE-DB Source has a AlwaysUseDefaultCodePage property, it is exposed in the property grid, not the custom UI. Set this to true. You could also just ignore the error, it will work, even in the preview window.
The same applies to Oracle, again they have not implemented code page support in the provider, same solution.
|||DarrenSQLIS wrote:
The DB2 OLE DB provider does expose code page information, so it is warning you of this fact. It also suggests a workaround/fix. The OLE-DB Source has a AlwaysUseDefaultCodePage property, it is exposed in the property grid, not the custom UI. Set this to true. You could also just ignore the error, it will work, even in the preview window.
The same applies to Oracle, again they have not implemented code page support in the provider, same solution.
Follow Darren's advice. Set the "AlwaysUseDefaultCodePage" to true and your warning will go away.|||
hi guys, not tested yet. That's for a colleague of mine.
thanks
No comments:
Post a Comment