CODEWITHSUNDEEP
sql-serverssisetl
Tara
Tara

Reputation: 83

ssis [File System Task] Error: An error occurred with the following error message: "Access to the path is denied."

So, I have an SSIS package that checks for file existence on the server, copies data from the file onto a table on sql server and moves the file to a done folder.

I have created environment variables and since I have full access to folders and to the server..the package got executed successfully. But, When I selected QA environment in the configuration manager and when I run the package..it's failing to move the file to the done folder and the error in execution result is - [File System Task] Error: An error occurred with the following error message: "Access to the path is denied.".

I have used user variables within the File system task

enter image description here

enter image description here

and the package overview

enter image description here

My question here is - since the file is present in file explorer on QA box and I don't have access..is it the reason for it to fail. But, I am not using my credentials to login at the connection manager level. I am using SQL server authentication (got a service account created).

Please let me know if you have any questions.

Thank you!

Upvotes: 0

Views: 8335

Answers (1)

Thom A
Thom A

Reputation: 95544

My question here is - since the file is present in file explorer on QA box and I don't have access..is it the reason for it to fail.

This is the reason for the failure, yes.

When running a SSIS package in Visual Studio most things will run under your credentials. Yes, you need to specify credentials for some connection managers, but File System Tasks use the Local User's credentials. If you, personally, do not have access to a file, neither does an SSIS package you are running.

Upvotes: 1

Related Questions