MSOLEDB connection manager

Question

I am using SSIS 2019 to create packages. In the list of connection manager driver, I cannot find MSOLEDBSQL,

There is a microsoft OLEDB for SQL server, but that is SQLOLEDB, as the microsoft online doc says both SQLOLEDB and SQLNCLI native client will be deprecated. For new development use MSOLEDBSQL, but I cannot find that driver in the list when I create new connection manager.

What do I miss?

Also in this MS doc, the built in connection manager list on this page, I cannot find MSOLEDBSQL,

https://learn.microsoft.com/en-us/sql/integration-services/connection-manager/integration-services-ssis-connections?view=sql-server-ver15

Do I have to download, it does not make sense MS ask to use the new driver, but it does not exist in the default connection manager driver list?

Thanks

Answer 1

Hi @Anne ,

May I know if you download Microsoft OLE DB Driver for SQL Server?

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Yes, that is correct.
I remember I chose that one but got an SQLOLEDB, maybe I chose another one.

Another try, it is like what you show me
thanks