Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

"Access to the path is denied" error in SSIS package Expand / Collapse
Author
Message
Posted Tuesday, January 10, 2012 8:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, January 03, 2014 3:52 PM
Points: 6,066, Visits: 5,277
jck.locke (1/10/2012)
Nimesh_Parikh (1/10/2012)

can you please check your Package Owner and Execution Owner both are same? Both of them should have permission on your all folders.


I have not deployed my package in SQL Server, I am using file system. In this case, will there be Package Owner or Execution Owner ?? If so then where I can find/change it

I think he is confused with DTS..
CEWII
Post #1233288
Posted Tuesday, January 10, 2012 12:35 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, January 03, 2014 3:52 PM
Points: 6,066, Visits: 5,277
That is really quite odd.. If the permissions at the folder and share levels are good all I can think of is file permissions and thats a stretch. but a file doesn't automagically take the permissions of the folder its in in all cases. If that isn't it I'm at a loss to explain..

CEWII
Post #1233469
Posted Wednesday, January 11, 2012 8:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, October 18, 2013 7:57 AM
Points: 26, Visits: 165
Elliott Whitlow (1/10/2012)
That is really quite odd.. If the permissions at the folder and share levels are good all I can think of is file permissions and thats a stretch. but a file doesn't automagically take the permissions of the folder its in in all cases. If that isn't it I'm at a loss to explain..

CEWII


I know, this error doesn't make any sense (and that is the reason why I posted it here for help ).

Post #1234052
Posted Wednesday, January 11, 2012 10:03 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 10:42 AM
Points: 20,460, Visits: 14,086
Has the on-site dba been able to successfully run the package from BIDS?



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1234163
Posted Monday, January 16, 2012 7:34 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, October 18, 2013 7:57 AM
Points: 26, Visits: 165
Finallyyyy . it's working !!
Apparently due to some strange extra permission issues, even though that proxy user had "FULL" control to the bottom of folder chain it was denying access to child folders.

After refusing many times, finally client security team agreed that issue was with their permissions not with SSIS package itself ...

Never mind, thanks everyone for their time to reply my question.

Jack
Post #1236614
Posted Monday, January 16, 2012 8:14 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, January 03, 2014 3:52 PM
Points: 6,066, Visits: 5,277
(angels heralding Alleluia)
Well it is good the mystery is solved because we were out of ideas..

CEWII
Post #1236637
Posted Wednesday, January 18, 2012 2:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 09, 2012 5:55 AM
Points: 14, Visits: 28
Thank you guys....
Post #1237765
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse