File System Task working until all of a sudden - access to path denied

Question

Post reply

File System Task working until all of a sudden - access to path denied

vee van gelder

Ten Centuries

Points: 1337
More actions
April 8, 2010 at 9:21 am

#143920

Hi there
Been running this package for more than a year, now all of a sudden getting this error in a for each loop container
[File System Task] Error: An error occurred with the following error message: "Access to the path 'U:\Selections FOPL\HC Proms' is denied.".
This is off a network drive, i am running this from BIDS not via the agent, i have permission on the network to copy the file (this is a copy not a move) and can access the file... this is driving me crazy, even if i copy the file on to my local drive and point to it i get this error.
any ideas??:w00t:

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

GregoryF SSCertifiable Points: 6296 More actions · Answer 1

Look at the ACL's on the file

/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

Phil Parkin SSC Guru Points: 246990 More actions · Answer 2

I've had unexpected problems with the File System task in the past. In the end, I threw in the towel and wrote a bit of script in a script task instead. Just two or three lines of code is usually all you'll need.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

vee van gelder Ten Centuries Points: 1337 More actions · Answer 3

I have read/write/execute and modify permissions which is all i need to copy

vee van gelder Ten Centuries Points: 1337 More actions · Answer 4

what a pain! was it also working fine for you and then suddenly?

Phil Parkin SSC Guru Points: 246990 More actions · Answer 5

vee van gelder (4/8/2010)
what a pain! was it also working fine for you and then suddenly?

No - mine was stuffed from the start 🙂

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

katrina78 Valued Member Points: 64 More actions · Answer 6

I understand your frustration, I encounter this a month ago anyway I solved it by downloading Long Path Tool.

Phil Parkin SSC Guru Points: 246990 More actions · Answer 7

katrina78 (2/2/2015)
I understand your frustration, I encounter this a month ago anyway I solved it by downloading Long Path Tool.

Can you elaborate on that please? I'm not sure what that is.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel