SSIS job is not able to access the Azure File share path

Question

Hi All,

I am testing the azure file share with SSIS hosted on Azure VM, however I am facing issue while running the job.

• Package execution through Visual Studio is successful
• Package execution through catalogue also is successful
• Package execution through the Job is FAILING with the error The File Name "\<Storage account>.windows.net\<FolderName>\file.csv" specified in the connection was not valid

I tried running the job with the proxy account having access to the azure share folder, however it failed with the same error.

Both UNC and as a mapped drive was tested.

Any suggestion or advice on this will be highly appreciated.

Thanks in advance.

Answer 1

@George Neel Thomas Welcome to Microsoft Q&A Forum, Thank you for posting your query here! Can you please share the screenshot of the issue?

Connect your Azure-SSIS IR to Azure Files by setting up access credentials that use Windows authentication. For more info, see Connect to data and file shares with Windows Authentication.

Update local file paths in your packages to UNC paths pointing to Azure Files. For example, update C:\abc.txt to \<storage-account-name>.file.core.windows.net\<share-name>\abc.txt.

Can you check port 445 port is enabled and also check the azure file share permissions for the folder

Configure File System Permissions for Database Engine Access

Please let us know if you have any further queries. I’m happy to assist you further.

---

Please do not forget to and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.