Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1574
  • Last Modified:

sql2012, ssis FileSystem Task return access is denied

Not sure why I got the error message access is denied when File System Task try to remove the file from the folder, I have verified that we have full access to the path and the sql agent which we use to run ssis via job have been configure with Local System
0
motioneye
Asked:
motioneye
1 Solution
 
John_VidmarCommented:
1. Use Universal Naming Convention (UNC) when fully-qualifying the filename.
2. Ensure no one has the file locked/open in another application.
3. Ensure the user running the SSIS Job has permission to get into the folder and delete that specific file.
4. Make sure firewalls are not blocking your actions.
0
 
motioneyeAuthor Commented:
excellent help :)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now