Azure' section in the SSIS toolbox is greyed out

Question

im upgrading from Visual Studio 2019 to 2022, but in VS 2022, but can't open or update the Azure Blob Storage connection manager. The 'Azure' section in the SSIS toolbox is greyed out, not letting us from adding or updating Azure Blob Source/Destination tasks. Do we need to install a specific extension to connect to Azure Blob Storage in VS 2022?

Answer 1

Hi there wesli

Thanks for using QandA platform

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.

reference - https://learn.microsoft.com/en-us/answers/questions/2100676/error-unable-to-create-the-type-with-the-name-azur

If this helps kindly accept the answer thanks much,

Answer 2

Hi @wesli

Welcome to Microsoft Q&A, thanks for posting your query here!

To connect to Azure Blob Storage in Visual Studio 2022, you need to install the Azure Feature Pack for Integration Services. This pack provides the tools needed to work with Azure services, including Azure Blob Storage.

If the Azure section in the SSIS toolbox is greyed out, it means the required tools are either not installed or not set up properly. Verify you download and install the correct version of the Azure Feature Pack that matches your SQL Server and Visual Studio versions. You can find it on the Microsoft website.

If the tools still don’t show up, you might need to add them manually. Right-click on the SSIS toolbox, select 'Choose Items', and navigate to the 'SSIS Data Flow Items' tab. Check the boxes for 'Azure Blob Storage Source' and 'Azure Blob Storage Destination', then click 'OK'. This will add them to your toolbox.

Reference:
https://learn.microsoft.com/en-us/sql/integration-services/azure-feature-pack-for-integration-services-ssis?view=sql-server-ver16#azure-feature-pack-for-integration-services-ssis
https://learn.microsoft.com/en-us/sql/ssdt/ssis-vs2022-troubleshooting-guide?view=sql-server-ver16#ssis-projects-extension-for-vs2022-troubleshooting-guide

Please feel free to contact if the issue persists, we will be glad to assist you closely. Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.