This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 4%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
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.
An Azure service that stores unstructured data in the cloud as blobs.
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 64%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Hi, we hope the provided answer helped if yes please accept the answer else, please let us know if you have any further queries. I’m happy to assist you further.
Hi, we hope the provided answer helped if yes please accept the answer else, please let us know if you have any further queries. I’m happy to assist you further.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 98%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
@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.
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.