Access to the path is denied.

  • HI All,

    I have designed an SSIS package for the below mentioned requirement.

    I receive flat files like csv files on daily basis. Which i have to import them to DB and move those inserted into Archive (separate folder).

    In the package for each loop event i had DB task and File System task. where it will insert into DB and have to move to different folder.

    But In this File System Task, i am getting an error Access to the path is denied.

    In Detail: I have a folder called "SOFTX" in which i have a sub folder "Archive".

    I receive flat files into SOFTX folder. From this folder i have to take each file, insert into DB and move that file to Archive folder. Here like when moving the file from SOFTX to Archive. I am receiving the following error "access to the path D:\SOFTX\Archive is denied".

    I am running this package on OS Windows XP, SP 3.

    Thanks in Advance,

    Waiting for your replies.

  • Is this a mapped drive?

    How are you running the package, in BIDS, SQL Server Agent Job, batch file?

  • Hi Jack,

    Thanks for your earlier response.

    No, this is not a Mapped drive.

    I am running the package in BIDS.

    I have attached a snapshot of the error, which gives you a clear view.

    Thanks In Advance,

    Waiting for reply.

  • Do you have access to that path? What version of windows are you on? If Vista/2008/maybe 7 you probably need to run BIDS with the admin bit set. You do that by right clicking on the BIDS icon and telling it to run as administrator. I seem to remember that it would usually warn you if you didn't do this..

    CEWII

  • Try Long Path Tool. It helped me in this situation. http://PathTooDeep.com 😀

Viewing 5 posts - 1 through 4 (of 4 total)

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