I am using Visual Studio (Community 2019) to manage existing SSIS Packages that is on a server. I need to pull data from an Azure SQL Managed Instance.
I'm pretty new to Azure but know my way around VS\SSIS. How do I create a connection manager in SSIS to the managed instance? I can connect to the Managed Instance in SSMS no problem.
After a bit of research, on the server where VS\SSIS reside, I have installed the Microsoft OLE DB Driver 18 for SQL Server that is supposed to provide native connectivity - however, I do not see it in the drop-down of Providers when creating a new OLE Connection.
Am I missing something?