File System Task Error

  • 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

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

    Russel Loski, MCSE Business Intelligence, Data Platform

  • hi,

    thanks for your reply.

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

    thanks

    regards

    viji

  • where can you change these options?

  • in the file system task -

    --> souce connection click new connection

    --> usage type change into existing folder.

    regards

    viji

  • 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

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

    Russel Loski, MCSE Business Intelligence, Data Platform

  • Thanks for your reply Russel.

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

    Thanks,

    Eranna

  • 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

  • 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

  • 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?

  • 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?

  • 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

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

    Eranna Kuruva

  • 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