SSIS Flexible file source Error when reading file from azure Blob storage

Question

I am getting the error below when trying to load a flat file (txt and csv) in an azure blob storage . I get the error below without much details to it. I have use 2022 and 2017 versions of azure extensions but same error. When I test the connection for ssis connection manager it is successful. Any thoughts and help please

[Flexible File Source 1] Error: Blob operation Failed. ContainerName: https://XXXXXXXX.blob.core.windows.net/harvestsherwood, path: XXXXXXX/HS-Atlanta7242024.csv.

Answer 1

Hi @Eobz

Try to remove the Flexible file source component and re-add it to run the package.

If this does not work, you may use Azure Blob Source as said in the blog.

How to import data from Azure Blob Storage to a local file with SQL Server Integration Services

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

@Eobz Make sure you are using the latest version of the Azure Feature Pack for SSIS.
Verify that the DtsDebugHost.config file is correctly configured. Sometimes, adding specific binding redirects can resolve issues related to assembly loading.

If you are still seeing issues, let me know in the comments and I can further investigate.