SSIS Azure storage connection manager missing

Question

SSIS Azure storage connection manager missing

Pat Snow 91

I'm using Visual Studio 2019. I installed the Azure feature pack for SSIS. The Azure storage connection manager is missing in SSIS. How do you add it?

Answer 1

ZoeHui-MSFT 20,076

Hi @Pat Snow ,

You need to go to Data Flow-->Azure Blob Source, and then you may configure the Azure storage connection manager like shown below.

Make sure that you have download the pack matches with your SQL Server version.

In addition, VS is a 32bit application, try to download the x86 version.

azure-feature-pack-for-integration-services-ssis

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.

Pat Snow 91 Reputation points

2022-08-18T14:18:46.09+00:00

Thank you for the screenshot. My Azure section in the SSIS Toolbox isn't enabled. I tried creating an Azure enabled SSIS project.
ZoeHui-MSFT 20,076 Reputation points

2022-08-22T09:29:24.163+00:00

Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)
Pat Snow 91 Reputation points

2022-08-26T15:55:26.217+00:00

Which one do you use to connect to an azure sql server DB?
ZoeHui-MSFT 20,076 Reputation points

2022-08-29T05:29:54.507+00:00

Hi @Pat Snow ,
Please refer to below:
https://www.mssqltips.com/sqlservertip/5514/using-azure-storage-and-azure-sql-database-for-ssis-development/

SSIS Azure storage connection manager missing

0 additional answers

Activity