Solved

sql2012, ssis FileSystem Task return access is denied

Posted on 2014-01-15
2
1,197 Views
Last Modified: 2016-02-10
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
Comment
Question by:motioneye
2 Comments
 
LVL 11

Accepted Solution

by:
John_Vidmar earned 500 total points
ID: 39783348
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
 

Author Closing Comment

by:motioneye
ID: 39811175
excellent help :)
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how the fundamental information of how to create a table.

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question