SSIS Cannot retrieve the column code page info from the OLE DB provider

Question

I'm working on SSIS Package which has oracle backend.

On OLE Command Task, I get the warning below:

"Cannot retrieve the column code page info from the OLE DB provider..."

I am aware that there is way to set AlwaysUseDefaultCodePage to true on OLEDB DataSource. But I've not seen how to fix on OLE Command Task.

Could someone please help? Also what are the consequence of not fixing this issue?

Answer 1

On the DataFlow task, open the Advanced Editor, select the Component Properties tab and in the Custom Properties section set the AlwaysUseDefaultCodePage to True