Access to the path is denied.

Question

Post reply

Access to the path is denied.

nagareddynaveen

SSC Journeyman

Points: 76
More actions
November 16, 2009 at 4:43 am

#216716

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.

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

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Is this a mapped drive?

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

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

nagareddynaveen SSC Journeyman Points: 76 More actions · Answer 2

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.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

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

gabrielko_47 SSC Enthusiast Points: 156 More actions · Answer 4

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