Method not found: &#39;Microsoft.WindowsAzure.Storage.Blob.CloudBlobClient Microsoft.DataTransfer.Runtime.AzureBlobConnectorHelper.CreateBlobClient(System.Collections.Gene... Task failed: Azure Blob Download Task

Question

Method not found: &#39;Microsoft.WindowsAzure.Storage.Blob.CloudBlobClient Microsoft.DataTransfer.Runtime.AzureBlobConnectorHelper.CreateBlobClient(System.Collections.Gene... Task failed: Azure Blob Download Task

medi_BI 1

Hello all,

I'm working with Azure feature pack for SSIS and keep getting an error when trying to download files from azure blob storage. The error i keep getting is the following:

Error: 0x0 at Azure Blob Download Task, Azure Blob Download Task: Download task has stopped with exception: Method not found: 'Microsoft.WindowsAzure.Storage.Blob.CloudBlobClient Microsoft.DataTransfer.Runtime.AzureBlobConnectorHelper.CreateBlobClient(System.Collections.Generic.IDictionary`2<System.String,System.Object>)'.
Task failed: Azure Blob Download Task

It seems that it has something to do with versioning, but i dot really know what to do after re-installing everything.

Thanks!

3 answers

Your answer

Answer 1

Michael Taylor 60,326

Did you enable TLS 1.2 in SQL Server as discussed in the installation instructions? I assume you are using the correct version of the Feature Pack for your version of SSIS but since this seems to be a call to Azure that is failing then that would be odd to me.

I would also make sure you are using the latest version. The release notes are pretty sparse but it seems like an issue like you're mentioning would have been detected during testing.

medi_BI 1 Reputation point

2021-09-30T14:54:58.74+00:00

@Michael Taylor
thank you for your response.

I have enabled TLS like it has been described in the installation instructions, but i'm still getting the same error.
I'm using the next versions:

Azure feature packs version 2019
Microsoft SQL Server Standard 2019 (64-bit) Version: 15.0.2000.5.

My VS version is: Microsoft Visual Studio Community 2019 Version 16.11.3.
SSIS version 3.15

I have tried everything i can think of but still not getting any progress on this.
Michael Taylor 60,326 Reputation points

2021-09-30T16:38:20.75+00:00

I tried a quick test and it worked fine for me. I used Azure Storage Emulator to run locally but that shouldn't matter. I'm using the SQL 2019 version.

It seems like maybe the wrong DLL is getting loaded. The first thing I wonder about is if you have upgraded your package from a previous version of the task? If that is true then it is possible it is using the older version of your task (unless the SSIS task included an upgrade template) which is now failing. To test this create a new SSIS package in the project, drop in Azure Blob Download Task on it and try to have it pull one of your documents. If it works then your existing package needs to be updated.

Answer 2

@Michael Taylor thank you for your response.

I have enabled TLS like it has been described in the installation instructions, but i'm still getting the same error.
I'm using the next versions:

Azure feature packs version 2019
Microsoft SQL Server Standard 2019 (64-bit) Version: 15.0.2000.5.

My VS version is: Microsoft Visual Studio Community 2019 Version 16.11.3.
SSIS version 3.15

I have tried everything i can think of but still not getting any progress on this.

Answer 3

EF Lin 1

Hi, is there a solution to this please? Took me quite awhile to enable the TSL using IISCrypto tool... now the Upload task is working. But I will getting the same issue here for the download task...

Share via

Method not found: &amp;#39;Microsoft.WindowsAzure.Storage.Blob.CloudBlobClient Microsoft.DataTransfer.Runtime.AzureBlobConnectorHelper.CreateBlobClient(System.Collections.Gene... Task failed: Azure Blob Download Task

3 answers

Your answer

Method not found: 'Microsoft.WindowsAzure.Storage.Blob.CloudBlobClient Microsoft.DataTransfer.Runtime.AzureBlobConnectorHelper.CreateBlobClient(System.Collections.Gene... Task failed: Azure Blob Download Task