Connection Manager Provider reverting back to SQL Native client from Oracle

Beacon77 131 Reputation points
2022-08-16T19:28:23.353+00:00

Hi All,
I have a SSIS Package, the DFT gets the data from SQL Server and does a look up the target table (Oracle database) and if there is match, it wont load any rows else will load new records. The target connection manager is Oracle Provider for OLEDB, but each time I open it reverts back to SQL Server native client 11.0.
This Package is called by another package, is that has to do something with this behavior? Please advice me where to look.
Thanks

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 32,506 Reputation points
    2022-08-17T05:38:20.323+00:00

    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.