CODEWITHSUNDEEP
sql-serverssis
Evaldas Buinauskas
Evaldas Buinauskas

Reputation: 14077

SSIS fails to access file with UNC path

I've deployed a SSIS package to SQL Server, which should read data from flat file, which is located here:

enter image description here

I can access path just fine from my local machine and I can run package from Visual Studio just fine too, however once I try to execute it on SQL Server, I get the following error:

enter image description here

Currently (just to debug) everyone has full access to this folder.

How do I fix it so my package works fine? (P.S. I don't have sysadmin rights, could it be the reason?)

I'm using Windows Authentication to login into SQL Server.

I execute my package from SSISDB. Screenshot for reference:

enter image description here

Upvotes: 0

Views: 4730

Answers (1)

Ria C
Ria C

Reputation: 77

Right click on folder, properties--> In security tab, check whether your server account is added with full control permission. Lastly you can share the folder where file is placed with everyone, better to skip this sharing though if previous one works

Upvotes: 0

Related Questions