SSIS - Access to the path is denied

Question

Post reply

SSIS - Access to the path is denied

Mahesh Bote

SSCrazy Eights

Points: 9107
More actions
March 18, 2010 at 1:30 am

#216684

[font="Verdana"]Hi All,
I have one SSIS package in which I have one task, i.e. Execute SQL Task with SQLSourceType = File Connection inside For Each Loop container. In the path specified for File Connection's property of Execute SQL Task, I have some DDL scripts. When I run the package, it throws Access to the path {folder path} is denied. error.
Can anybody explain, being an Administrator why such error is occuring?
Thanks in advance,
Mahesh
[/font]
MH-09-AM-8694

Viewing 13 posts - 1 through 12 (of 12 total)

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

vee van gelder Ten Centuries Points: 1337 More actions · Answer 1

did you ever manage to find out what the problem was i am having the same problem.

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 2

What permissions is SSIS running under? Does it have rights to the file?

vee van gelder Ten Centuries Points: 1337 More actions · Answer 3

well as far as i know it runs under my name when im running it on my local in bids and its always worked before.

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 4

Is there any additional detail in the Execution Results tab?

vee van gelder Ten Centuries Points: 1337 More actions · Answer 5

vee van gelder

Ten Centuries

Points: 1337

April 9, 2010 at 12:19 am

#1148837

nope unfortunately thats all it says

kastros.george Old Hand Points: 399 More actions · Answer 6

the problem seems to be absolute path on different machines....

when you have a package on BIDS on your machine and you reference a file like c:\somfile everything works ok...

When you deploy the package and try to execute it from for example sql server using tsql or something, then the package gets executed on the remote machine

so c:\somefile doesnot have any meaning ....

it is a good idea in general to use network shares as file repositories

Alan. T. Hall of Fame Points: 3221 More actions · Answer 7

I believe when you use the execute SQL task like that is uses the permissions of the service running SQL server for authentication. Does the SQL server users have authority to the path in question. I do not think your authority matters.

talha kamran SSC Enthusiast Points: 104 More actions · Answer 8

I am having the same problem.

System.UnauthorizedAccessException: Access to the path is denied.

How to enable SQLServer to access local drives on server?

Thanks,

Kamran

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 9

talha kamran (5/4/2011)
I am having the same problem.
System.UnauthorizedAccessException: Access to the path is denied.
How to enable SQLServer to access local drives on server?
Thanks,
Kamran

The SQLServer service runs under a specific account. You can check it in the configuration manager. You need to give this account the necessary permissions to the folders.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

WILLIAM MITCHELL SSChampion Points: 13766 More actions · Answer 10

You may need to create a proxy account & have the SSIS run under that account. The proxy account would need permission to access the particular folders / files.

rferreira.dba Old Hand Points: 301 More actions · Answer 11

I was having the same issue. Solution was to right click Data Tools and "Run as administrator". That solved the problem. Raphael

katrina78 Valued Member Points: 64 More actions · Answer 12

windows has its limit of 256 characters that's why we encounter errors like this. Long Path Tool is an easy fix for this situation.