Post reply

File System Task Error

  • December 25, 2008 at 10:18 am

    #155056

    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

  • January 2, 2009 at 10:34 am

    #920426

    When do you get this error? Running BIDS or when the package is deployed?

    Russel Loski, MCSE Business Intelligence, Data Platform

  • January 2, 2009 at 1:00 pm

    #920503

    hi,

    thanks for your reply.

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

    thanks

    regards

    viji

  • May 14, 2009 at 2:37 pm

    #994904

    where can you change these options?

  • May 14, 2009 at 10:49 pm

    #995059

    in the file system task -

    --> souce connection click new connection

    --> usage type change into existing folder.

    regards

    viji

  • July 20, 2009 at 12:36 pm

    #1027238

    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

  • July 20, 2009 at 3:09 pm

    #1027304

    Does it work when you are using BIDS then fail when using SQL Agent?

    Russel Loski, MCSE Business Intelligence, Data Platform

  • July 20, 2009 at 5:05 pm

    #1027347

    Thanks for your reply Russel.

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

    Thanks,

    Eranna

  • July 20, 2009 at 7:46 pm

    #1027385

    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, MCSE Business Intelligence, Data Platform

  • July 21, 2009 at 1:44 pm

    #1027889

    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

  • July 8, 2010 at 4:53 pm

    #1190552

    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?

  • August 25, 2011 at 8:09 am

    #1373170

    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?

  • August 25, 2011 at 8:53 am

    #1373212

    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

  • August 25, 2011 at 9:03 am

    #1373222

    It happens. It is a learning process every body go through. Have fun

    Eranna Kuruva

  • February 17, 2012 at 11:15 am

    #1448677

    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?

Viewing 15 posts - 1 through 15 (of 16 total)

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