Share via

Azure Blob Upload and Download Tasks Failing in SSIS

Eli Kent 36 Reputation points
2022-03-09T15:57:21.523+00:00

I'm trying to connect SSIS to Azure Blob Storage for the first time.

I created the connection manager and the connection test succeeded. Created an Upload Task. Also created a Download Task. Both failed. Triple checked the info in set-up. Can't figure out why it's failing. I'm not getting any error messages in the debugger (screenshots below). Any ideas?

Debugger
181495-image.png

Set-up
181469-image.png

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Eli Kent 36 Reputation points
    2022-03-14T16:43:07.193+00:00

    for those following at home, with guidance i was able to fix the problem.

    it turns out the minimum TLS version for Azure storage accounts is set to 1.2, whereas the default for Azure Feature Pack is 1.0.

    two options to fix.
    1- the simpler but less secure method: in storage account configuration, decrease minimum TLS version to 1.0, which downgrades security

    2- the more secure but more complex method: add two DWORDs to Registry Editor as described here

    hope that helps anyone having this issue

    2 people found this answer helpful.
    0 comments
  2. Olaf Helper 47,516 Reputation points
    2022-03-10T08:36:25.173+00:00

    On button right you have tab "Task List" opened; of course you don't see any error there.
    Change to left tab "Error List" to get them.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.