[OLE DB Destination [761]] 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.

[OLE DB Destination [761]] 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.



To resolve this error perform the below steps

1. Double click on the Data flow task

2. Right Click on the OLE DB SOurce data flow task.  

3. Then go to the properties tab and set the AlwaysUseDefaultCodePage peoprty to True.