Connect to ADLS Gen 2 from SSIS 2019

Raj D 581 Reputation points
2023-12-21T00:32:57.1633333+00:00

Hello

I'm trying to import files from ADLS Gen 2 container using SSIS 2019 Azure feature pack. Azure storage connection manager succeeds but when I use the Azure Blob Download Task I get the following error.

https://myblob.blob.core.windows.net/, Container Name: mycontainer

Error: [Azure Blob Download Task] Error: Download task has stopped with exception: The remote server returned an error: (403) Forbidden.

I tried using Flexible File Task and get the following error. Error: [Flexible File Task] Error: Blob operation Failed. ContainerName: mycontainer, path: . The remote server returned an error: (403) Forbidden. The remote server returned an error: (403) Forbidden.

Not sure what might be causing this issue.

Thank you

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,440 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,459 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rhayar Mascarello 100 Reputation points
    2023-12-21T11:10:10.9833333+00:00

    Hello!

    This error is usually caused by a lack of permissions to access the resource. Here are some possible reasons why you might be seeing this error:

    The storage account key you are using to authenticate does not have the necessary permissions to access the container. You can try regenerating the storage account key and updating the connection manager in SSIS to use the new key.

    The firewall settings on the storage account are blocking access to the container. You can check the firewall settings on the storage account and ensure that your IP address is whitelisted.

    The SAS token you are using to authenticate has expired. You can generate a new SAS token and update the connection manager in SSIS to use the new token.

    The container you are trying to access does not exist or has been deleted. You can check that the container exists and that the name is spelled correctly.