Getting access deni when running a package

Question

Getting access deni when running a package

river1

SSC-Insane

Points: 24302
More actions
September 12, 2017 at 8:24 am

#349119

Hello,
I have created a package to copy some files from a directory D:\FicheirosZipadosDiarios'
I am getting an error saying that the access is denied. This is denied to m windows user or to other user? (I am in desing mode using SSDT to run the package).
Thank you.
error:
SSIS package "C:\Users\pribeiro.NOVAWARE\Desktop\SSIS_Projects\ImportaFicheiroZippados\ImportaFicheiroZippados\Package.dtsx" starting.
Error: 0xC002F304 at Copy and extract zip file into temp directory, File System Task: An error occurred with the following error message: "Access to the path 'D:\FicheirosZipadosDiarios' is denied.".
Task failed: Copy and extract zip file into temp directory
Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "C:\Users\pribeiro.NOVAWARE\Desktop\SSIS_Projects\ImportaFicheiroZippados\ImportaFicheiroZippados\Package.dtsx" finished: Failure.

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

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

Thom A SSC Guru Points: 99126 More actions · Answer 1

If you're running in design mode in Visual Studio's SSDT, then the user account being denied is your user account (as you are the one running the package). Thus your account does not have permission to the path D:\FicheirosZipadosDiarios.

Edit: Generally, it's better to use UNC path, rather than the (mapped) Drive letter, as you can ensure that regardless of the location the path will be found.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

river1 SSC-Insane Points: 24302 More actions · Answer 2

Thank you for your reply . But this the UNC as the folder is FicheirosZipadosDiarios under d:

My account as permissions. I am administrator my machine.

Do you have any other suggestion?

Thank you

Thom A SSC Guru Points: 99126 More actions · Answer 3

river1 - Tuesday, September 12, 2017 8:38 AM
Thank you for your reply . But this the UNC as the folder is FicheirosZipadosDiarios under d:
My account as permissions. I am administrator my machine.
Do you have any other suggestion?
Thank you

The UNC (Universal Naming Convention) path, normally, would be the share name, or otherwise the direct network path. So, say I have a directory MyFiles on C: of the server FileServer01 mapped to the drive F:\, the UNC path isn't F:\, it would either be \\FileServer01\C$\MyFiles or \\FileServer\[ShareName] (if you have a share set up). Using just D:\ isn't normally an issue for you, but your SQL server won't know what D:\ is in relation to the combination of your PC and User. Thus, when creating packages, it's always best use the UNC path; as the name suggests, the path is universal on your network, where as Drive Letters are Computer and user specific.

And just because you're an administrator doesn't instantly mean you have full access to the root of your D:\. For example, I am an administrator of my PC, however, I can't write straight to C:\. If I try to do so, a dialogue window appears asking me that an administrator has to allow me to do so. I am one, yes, but I still have to tell it it's ok to do. Generally speaking, this happens a lot on the root directory of a drive, it's not where you should be storing files. You should be storing them in a directory (which may be stored in the root, or another directory).

Firstly, ensure that you have Full Control on the root of your D:\. Secondly, if that still fails, try creating a directory on D:\, and then putting your files in there instead. I would not be surprised if the latter works, while the former does not.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

river1 SSC-Insane Points: 24302 More actions · Answer 4

Hello,

Thank you for your support.

But d: has already that directory which is FicheirosZipadosDiarios. This is the directory that I am trying to access. Not the d:

Thom A SSC Guru Points: 99126 More actions · Answer 5

river1 - Tuesday, September 12, 2017 9:10 AM
Hello,
Thank you for your support.
But d: has already that directory which is FicheirosZipadosDiarios. This is the directory that I am trying to access. Not the d:

Apologies, yes, you do have a directory; however, this does mean you don't have permissions on that directory. You'll need to check your permissions and amend them.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk