Access to the path is denied.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Access to the path is denied.

Access to the path is denied.

Rate Topic

Display Mode

Topic Options

Author

Message

nagareddynaveen

Posted Monday, November 16, 2009 4:43 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 28, 2010 6:02 AM
Points: 2, Visits: 12

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.

Post #819294

Jack Corbett

Posted Monday, November 16, 2009 7:06 AM

SSChampion

Group: General Forum Members
Last Login: 2 days ago @ 12:22 PM
Points: 10,571, Visits: 11,871

Is this a mapped drive?

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

Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2

Post #819361

nagareddynaveen

Posted Monday, November 16, 2009 7:44 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 28, 2010 6:02 AM
Points: 2, Visits: 12

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.

Post Attachments

SSIS_Progress.bmp (10 views, 3.16 MB)

Post #819387

Elliott Whitlow

Posted Monday, November 16, 2009 7:58 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

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

Post #819393

gabrielko_47

Posted Tuesday, October 02, 2012 12:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, October 11, 2012 6:44 AM
Points: 4, Visits: 52

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

Post #1366872

« Prev Topic | Next Topic »

Permissions