This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I'm trying to connect to ADLS Gen2 from SSIS using an Azure Storage Connection Manager using a service account & Service Principal authentication. I'm using the Key Vault client ID for the application ID and secret key for the Application key. I'm using the Azure Active Directory tenant ID. I'm getting Test connection failed: Blob operation failed. File sys. Any thoughts?
![](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(294.40000000000003, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Hi atrapp,
The following links will be helpful:
Best Regards,
Mona
----------
If the response is helpful, please click "Accept Answer" and upvote it.
Hi @Monalv-MSFT ,
Thanks for your guidance. The error that I received above isn't referenced on either of the pages to which you directed me.
Do you have any other ideas or do you know someone else that may be able to assist? Our Azure Infrastructure team doesn't know SSIS and can't help and everything I've researched so far isn't helping with this error.
Regards,
Angela
Hi @Monalv-MSFT ,
I finally figured out the issue. Yes, it was the values entered in the Azure Storage connection manager but I couldn't figure out at first what value was wrong. It was the Account Name field.
Although documentation does state it, it would help if the Account Name field in the Azure Storage connection manager was labeled Storage Account Name instead of Account Name. I erroneously had the Service Account Name in that field.
Regards,
Angela
Hi @Angela ,
If the answer is helpful, please click "Accept Answer" and upvote it. Thank you.
Best Regards,
Mona