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

I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this!

Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer. Accepted answers show up at the top, resulting in improved discoverability for others.

Issue: "Unable to create the type with the name 'AzureStorage'" in Visual Studio 2022 means that there is an issue with creating an instance of the 'AzureStorage' type.

Solution: 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.

If your issue remains unresolved or have further questions, please let us know in the comments how we can assist. We are here to help you and strive to make your experience better and greatly value your feedback.

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

---

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

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 3

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.