Error: Unable to create the type with the name 'AzureStorage'- visual studio 2022

Question

We are looking at upgrading from Visual Studio 2019 to Visual Studio 2022. We have a few packages that are using Azure Blob Destination and Azure Blob Source tasks to upload/download data from SSIS to Azure Blob. In Visual Studio 2019, we have an Azure Storage Connection Manager that is created to connect to Azure Blob (including account name and access key). This is working in VS 2019 and we are able to run the packages as well update the connection manager and Azure tasks for Azure Storage.

However, in Visual studio 2022, we cannot open/update the Azure Blob Storage connection manager. 'Azure' in SSIS 2022 toolbox is also greyed out and hence a new Azure Blob Destination task and/or Azure Blob Source task cannot be added/updated in the package. Is there a specific extension that we will need to download to connect to Azure Blob Storage in VS 2022?

Answer 1

Hi Noveen Haseeb,

Welcome to Microsoft Q&A Forum, thank you for posting your query here!

Please install the below extensions to view the storage account

"SQL Server Integration Services (SSIS) Feature Pack for Azure"

https://learn.microsoft.com/en-us/sql/integration-services/connection-manager/azure-storage-connection-manager?view=sql-server-ver16

Please let us know if you have any further queries. I’m happy to assist you further. 

Hope this helps!

Kindly let us know if the above helps or you need further assistance on this issue.

---

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

 

Answer 2

Right-click on the SSIS project, go to Properties > Configuration Properties > General, and ensure the TargetServerVersion matches the SQL Server version you intend to use (e.g. SQL Server 2022) and Azure feature pack 2022 is installed. Also, a new Azure storage should be created and updated for each package. Make sure the AzureFeaturePack and TargetServerVersion should be same.