[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1652
  • 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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