SSIS Azure Blob Upload Task: unable to create blob container

Paolo Cos 31 Reputation points
2022-10-07T14:23:20.177+00:00

There's a SSIS Azure Blob Upload Task which is logging the following error while uploading a file to a blob container of an Azure Storage:

Unable to create Azure Blob container [...] Container Name: dmd-to-cdinfra.

The block started to log this error from more or less one month ago, before it worked like a charm.The container in the storage does exist and I have configured an App Registration on the app policies to enable the AppReg to upload files:

248480-image.png

The SSIS Azure Blob Upload Task block uses this Connection Manager to connect to the storage specific Blob Container (dmd-to-cdinfra)

248428-image.png

The SSIS is deployed on SQL Server on a VM which runs Windows Server 2016.

Following this article https://learn.microsoft.com/en-us/mem/configmgr/core/plan-design/security/enable-tls-1-2-client I added the keys to the registry and restarted the VM, the error is still there.

Following this Stack Overflow https://stackoverflow.com/questions/47299067/ssis-azure-blob-dw-upload-task-error I added other keys to the registry, with no success.

Any suggestion is appreciated

Best regards,
Paolo

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator
    2022-10-09T14:25:13.767+00:00

    Hi, @Paolo Cos Thanks for posting the question and for using Azure Services.
    Blob Upload Task is deprecated. Try Flexible File Task. If the issue persists,

    Regards
    Geetha


Your answer

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