Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

File System Task Error Expand / Collapse
Author
Message
Posted Thursday, July 8, 2010 4:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 15, 2013 10:27 AM
Points: 1, Visits: 38
I have the same problem..
The package works fine when copy folder option is used.
But I get the access to path denied error message when copy file option is used.

so do i need to have system admin permission?
Post #949656
Posted Thursday, August 25, 2011 8:09 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 4:49 AM
Points: 16, Visits: 120
I've got the exact same problem.

I'm on Windows XP professional and using my laptop for development.

I've got environment variables point to a Work and Source directory

The work directory is C:\Universe\Tax
The Source directory c:\TmpSource\Tax

When I run the package through BIDS, the first task is a FileSystem Task - delete directory contents on the work directory - this is successful (although there are no files)

The next task is a file system task to copy from C:\TmpSource\Tax to C:\Universe\Tax

This files with Access to the path 'C:\tmpsource\Tax' is denied

I can browse the source directory successfully through using run

Any ideas?
Post #1165373
Posted Thursday, August 25, 2011 8:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 4:49 AM
Points: 16, Visits: 120
Please forget my comment.

This was totally my error.

I had the wrong system task defined - which is a way of learning... if somewhat frustrating
Post #1165421
Posted Thursday, August 25, 2011 9:03 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 11:46 AM
Points: 77, Visits: 273
It happens. It is a learning process every body go through. Have fun

Eranna Kuruva
Post #1165434
Posted Friday, February 17, 2012 11:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 17, 2012 2:35 PM
Points: 3, Visits: 22
I´m having the same problem, if i paste the path in RUN i can browse the folder in windows explorer, but when i run BIDS it fails.

any suggestion?
Post #1254058
Posted Friday, February 17, 2012 11:21 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
Carlos russo (2/17/2012)
I´m having the same problem, if i paste the path in RUN i can browse the folder in windows explorer, but when i run BIDS it fails.

any suggestion?

Have you tried running BIDS as administrator?
Post #1254068
Posted Friday, July 26, 2013 1:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 26, 2013 1:28 AM
Points: 1, Visits: 0
Hi,

I am new for this, Please help me .

I am getting the Error as:

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

How to solve this? what is the reason to get path as '0'?
Post #1477892
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse