Unable to Download File from an Azure Blob Conatiner Using SSIS

hmrios74 1

I'm trying to download a file from an Azure Blob container using the Azure Blob Download Task in SSIS but I'm getting the error below.

**[Azure Blob Download Task] Error: Download task has stopped with exception: Method not found: 'Microsoft.WindowsAzure.Storage.Blob.CloudBlobClient Microsoft.DataTransfer.Runtime.AzureBlobConnectorHelper.CreateBlobClient(System.Collections.Generic.IDictionary`2

SaiKishor-MSFT 17,216 Reputation points

2022-09-15T19:06:54.383+00:00

@hmrios74 Thanks for reaching out to Microsoft Q&A. Can you please share the download task that you have for this scenario as per - https://video2.skills-academy.com/en-us/sql/integration-services/control-flow/azure-blob-download-task?view=sql-server-ver16? Thank you!
Oury Ba-MSFT 17,631 Reputation points Microsoft Employee

2022-09-23T17:18:06.827+00:00

Hi @hmrios74 Please do also refer to this thread https://video2.skills-academy.com/en-us/answers/questions/1019682/where-is-the-azure-blob-directory.html?redirectedFrom=1019802 and let us know if it is helpful.

Regards,
Oury
Oury Ba-MSFT 17,631 Reputation points Microsoft Employee

2022-09-26T16:45:15.887+00:00

Hi @hmrios74
Please let us know if that resolve your issue.

Regards,
Oury
Yinan Danilowicz - Morristown 0 Reputation points

2023-02-22T21:21:53.6166667+00:00

I'm getting the same error message.
I migrated SSIS package from Target 2014 to Target 2019. I downloaded Azure Feature pack 2019. Azure blob upload task works fine. But I got this error message when executing Azure blob download task.

I checked that TLS1.2 registries are in place.

Please help.

Best Regards
Sameera Nouelati 0 Reputation points

2023-02-27T19:34:49.01+00:00

I am also getting the same error message. I am using VS 2017, I also added the two required entries in the registry.

I can use the Azure Blob Upload Task and the Azure Blob Download Task successfully, unfortunately the Azure Blob Source is giving this error message:

Severity Code Description Project File Line Suppression State

Error Validation error. Data Flow Task: Data Flow Task: Method not found: 'Microsoft.WindowsAzure.Storage.Blob.CloudBlobClient Microsoft.DataTransfer.Runtime.AzureBlobConnectorHelper.CreateBlobClient(System.Collections.Generic.IDictionary`2<System.String,System.Object>)'. Package.dtsx 0

Please help.

3 answers

Oury Ba-MSFT 17,631 Reputation points Microsoft Employee

2023-03-23T20:41:35.5366667+00:00
@hmrios74 Sameera Nouelati, Yinan Danilowicz - Morristown

Could you please try the below.

Make sure that the Azure Storage SDK for .NET is installed on the machine where the SSIS package is running.

Check that the version of the Azure Storage SDK for .NET is compatible with the version of the Azure Blob Download Task in SSIS.

Verify that the Microsoft.WindowsAzure.Storage.Blob.CloudBlobClient class is included in the project references and that the correct namespace is being used.

Regards,

Oury
Please sign in to rate this answer.

0 comments No comments
Sign in to comment
Rick Girling 0 Reputation points

2023-10-04T15:56:42.4566667+00:00

Has there been a solution for this issue? I have followed the install directions, have all the correct versions and still have the same issue, cant get past it.

Thanks,

Rick
Please sign in to rate this answer.

0 comments No comments
Sign in to comment
Chawinwat 0 Reputation points

2024-05-24T03:39:04.69+00:00

I am using Visual Studio2019, I have the same issue.
Has there been a solution for this issue?
Please sign in to rate this answer.
Sumarigo-MSFT 44,891 Reputation points Microsoft Employee

2024-05-28T07:01:42.8666667+00:00

@Chawinwat I would recommend to please create new thread with all the details of your issue. https://video2.skills-academy.com/en-us/answers/questions/ask/
Sign in to comment

Share via

Unable to Download File from an Azure Blob Conatiner Using SSIS

3 answers