graandrews
asked on
SSIS Lookup component "Warning: Cannot retrieve the column code page info from the OLE DB provider"
Hi,
I have a very basic SSIS package which copies records from a SQL database table to an Oracle database table. Although it executes correctly without error, there is a persistent 'WARNING' icon on the lookup component. The warning is:
[Lookup [2]] Warning: 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.
I have resolved this same warning on the OLE DB source and destination components by setting the property "AlwaysUseDefaultCodePage" to TRUE but the LOOKUP component does not seem to have this property.
My question is:
Is there something I can do to resolve this warning on the LOOKUP component in the data flow or is it ok to ignore it as the package executes successfully?
Thank you for your help! (I am new to SSIS...) I am developing the package using Visual Studio 2010 Shell
This is a screenshot of the data flow so you can see the warning is on the lookup component:
I have a very basic SSIS package which copies records from a SQL database table to an Oracle database table. Although it executes correctly without error, there is a persistent 'WARNING' icon on the lookup component. The warning is:
[Lookup [2]] Warning: 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.
I have resolved this same warning on the OLE DB source and destination components by setting the property "AlwaysUseDefaultCodePage"
My question is:
Is there something I can do to resolve this warning on the LOOKUP component in the data flow or is it ok to ignore it as the package executes successfully?
Thank you for your help! (I am new to SSIS...) I am developing the package using Visual Studio 2010 Shell
This is a screenshot of the data flow so you can see the warning is on the lookup component:
ASKER
Thank you for the response Pawan Kumar :) I have already done this and set AlwaysUseDefaultCodePage to True on both the OLE DB Source and OLE DB Destination components. The warning is on the "Lookup" component and it does not have the "AlwaysUseDefaultCodePage" property in the advanced editor/component properties.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you Manju, I am happy that you confirmed that I can safely ignore the warning. The package works well, that was my only concern. Thanks again!
Open in new window
https://msdn.microsoft.com/en-us/library/aa705760(v=bts.10).aspx