question

MichaelHutcheson-0373 avatar image
0 Votes"
MichaelHutcheson-0373 asked ZoeHui-MSFT commented

How to connect SSIS to an Azure Managed Instance

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?

sql-server-generalazure-sql-databasesql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi @MichaelHutcheson-0373,

You may use ‘ADO.NET connection’ manager to connect to the Azure Managed Instance.

If you want to connect to Azure DB by using "Native OLE DB\SQL Server Native Client 11.0" provider, details you may refer: step-by-step-connecting-to-azure-sql-server-using-oledb-connection-from-ssis

Hope it could give you some ideas.

Regards,

Zoe


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.
Hot issues October


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

May I know how's the issue going on now? If you have any updates, don't forget to tell us.

0 Votes 0 ·