Hi @Beacon77 ,
From my test, if you have configured the Oracle Provider for OLEDB successfully, it will not get back to SQL Server native client 11.0.
If you are creating the new OLEDB source, the default is SQL Server native client 11.0, you may need to choose the Oracle Provider if you need.
If you are using lookup to match with different Oracle Connection Manager , you may need to re-configure it.
If I misunderstand your issue, please incorrect me.
Regards,
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.