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, December 25, 2008 10:18 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:11 AM
Points: 317, Visits: 929
Hi,

I'm using SSIS2005 and i want to move one file from source to destination.

I'm trying with File System Task.
I've assigned two variables for source and destination.

while running i'm getting an error

[File System Task] Error: An error occurred with the following error message: "Access to the path 'C:\ClientAdmin\Location\warehouse' is denied."



Thanks,
Regards,
Viji
Post #625677
Posted Friday, January 2, 2009 10:34 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, June 7, 2014 4:22 AM
Points: 565, Visits: 8,703
When do you get this error? Running BIDS or when the package is deployed?

Russel Loski, MCITP
Post #628965
Posted Friday, January 2, 2009 1:00 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:11 AM
Points: 317, Visits: 929
hi,
thanks for your reply.

it got solved once i changed the "existing file" to "existing folder" option

thanks
regards
viji
Post #629052
Posted Thursday, May 14, 2009 2:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 9, 2009 2:48 PM
Points: 4, Visits: 23
where can you change these options?


Post #717403
Posted Thursday, May 14, 2009 10:49 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:11 AM
Points: 317, Visits: 929
in the file system task -

--> souce connection click new connection
--> usage type change into existing folder.

regards
viji
Post #717585
Posted Monday, July 20, 2009 12:36 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 20, 2014 6:59 PM
Points: 77, Visits: 266
Hi Viji,

I am using the source and destination connections as variables ( mentioning paths in them ), but i am facing the same issue " Access denied to. I am using the variable value as C:\aa\aa.

Pls let me know if know the solution

Thanks,
Eranna

Post #756108
Posted Monday, July 20, 2009 3:09 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, June 7, 2014 4:22 AM
Points: 565, Visits: 8,703
Does it work when you are using BIDS then fail when using SQL Agent?

Russel Loski, MCITP
Post #756191
Posted Monday, July 20, 2009 5:05 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 20, 2014 6:59 PM
Points: 77, Visits: 266
Thanks for your reply Russel.

I still did not test with SQL Agent. Its failing in BIDS.

Thanks,
Eranna
Post #756248
Posted Monday, July 20, 2009 7:46 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, June 7, 2014 4:22 AM
Points: 565, Visits: 8,703
If you paste "C:\aa\aa" in Run, you are able to browse to that folder? And whatever you want to do in that folder (write to it, read from it) you can do in the Explorer window?

Russel Loski, MCITP
Post #756291
Posted Tuesday, July 21, 2009 1:44 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 20, 2014 6:59 PM
Points: 77, Visits: 266
The problem is resolved. I was not admin on my system and that was causing this issue.
I am yet to test this with SQL Agent.

Thanks for your time.

Eranna
Post #756916
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse