Are you in a clustered environment? On the surface you are dealing with a security issue, did you try to run the package using DTExec?Arthur My Blog

Just to clarify. You run gzip from the command prompt you are able to unzip a file. However when you are designing a package with BIDS that includes an Execute Process Task that calls gzip to unzip from the same file to the same folder as you did with the command prompt and you debug the package, you get the above errors.Russel Loski, MCT

Hi, thanks for the pointer, I've narrowed it down to a problem running an executable on a share on the server. When I use the UNC path (servername\sharename) to the share within the executable task in the package it doesn't work when I run it on the server, but I can run it successfuly from my own pc. When I change the unc path in the execurable package to the local drive mapping on the server I can then run the package on the server. I've tried creating a new share on the server and I get exactly the same problem. I'm going to try recreating the original share this afternoon, I don't believe this will work as the new share doesn't work. I'm going to reboot this server within the cluster tomorrow, to see if this resolves the problem. I would rather not change all the paths to local paths within the packages. Any other suggestion or pointers would be welcome. Sean

Yes it is a clusterd environment. I've tried running from the command prompt using dtexec.Sean

yes when I run from the command prompt I can unzip the file ok as the appropriate user, it is just when I ran an SSIS package whether from sqlagent or directly on the box it fails on any execute process step with "Access is Denied". I am currently running the same packages from my pc, connecting to the production server and they run successfully. Sean

It seems that your cluster has recently flipped to another node. I guess where you are running the package the SSIS engine cannot reach out to a share or another file location. Do you use remote paths or trying to access another drive in your package? Arthur My Blog

Hi, I've a number of SSIS packages that have stopped working on a production server. The SSIS packages that have stopped working all seem to fail on the execution of an externel executable. I'm getting an access denied error. I've tried creating a new package on the server but I get the same error. The test package contains a single task that is performing a gzip.exe to unzip a file. I can execute this gzip command and it'll work, however when I run the package it fails on this task This packages where working yesterday which implies that something has changed but I can't see what it is. The following log iss from running the package outside of SQL. I've been through any number of posts trying to correct this problem, but with no success. I'd be very grateful for any suggestions, I'm preparing to reboot the server, but only as a last resort. #Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message OnPreValidate,MY-SERVER,MY-DOMAIN\MY_USER,seantest2,{ED64B05A-F51B-4432-BCD7-ABC3C96E8574},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:45,13/01/2011 14:01:45,0,0x,(null) OnPostValidate,MY-SERVER,MY-DOMAIN\MY_USER,seantest2,{ED64B05A-F51B-4432-BCD7-ABC3C96E8574},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:45,13/01/2011 14:01:45,0,0x,(null) tValidate,MY-SERVER,MY-DOMAIN\MY_USER,unzip,{CF810406-12AA-4ED2-AE05-0938176A5BD0},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:45,13/01/2011 14:01:45,0,0x,(null) OnPostValidate,MY-SERVER,MY-DOMAIN\MY_USER,seantest2,{ED64B05A-F51B-4432-BCD7-ABC3C96E8574},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:45,13/01/2011 14:01:45,0,0x,(null) OnPreValidate,MY-SERVER,MY-DOMAIN\MY_USER,seantest2,{ED64B05A-F51B-4432-BCD7-ABC3C96E8574},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:45,13/01/2011 14:01:45,0,0x,(null) OnPostValidate,MY-SERVER,MY-DOMAIN\MY_USER,seantest2,{ED64B05A-F51B-4432-BCD7-ABC3C96E8574},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:45,13/01/2011 14:01:45,0,0x,(null) tValidate,MY-SERVER,MY-DOMAIN\MY_USER,unzip,{CF810406-12AA-4ED2-AE05-0938176A5BD0},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:45,13/01/2011 14:01:45,0,0x,(null) OnPostValidate,MY-SERVER,MY-DOMAIN\MY_USER,seantest2,{ED64B05A-F51B-4432-BCD7-ABC3C96E8574},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:45,13/01/2011 14:01:45,0,0x,(null) PackageStart,MY-SERVER,MY-DOMAIN\MY_USER,seantest2,{ED64B05A-F51B-4432-BCD7-ABC3C96E8574},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:45,13/01/2011 14:01:45,0,0x,Beginning of package execution. Diagnostic,MY-SERVER,MY-DOMAIN\MY_USER,seantest2,{ED64B05A-F51B-4432-BCD7-ABC3C96E8574},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:45,13/01/2011 14:01:45,0,0x,Based on the system configuration, the maximum concurrent executables are set to 10. OnPreExecute,MY-SERVER,MY-DOMAIN\MY_USER,seantest2,{ED64B05A-F51B-4432-BCD7-ABC3C96E8574},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:45,13/01/2011 14:01:45,0,0x,(null) OnError,MY-SERVER,MY-DOMAIN\MY_USER,seantest2,{ED64B05A-F51B-4432-BCD7-ABC3C96E8574},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:45,13/01/2011 14:01:45,-1073548540,0x,An error occurred with the following error message: "Access is denied". OnWarning,MY-SERVER,MY-DOMAIN\MY_USER,seantest2,{ED64B05A-F51B-4432-BCD7-ABC3C96E8574},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:46,13/01/2011 14:01:46,-2147381246,0x,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. OnPostExecute,MY-SERVER,MY-DOMAIN\MY_USER,seantest2,{ED64B05A-F51B-4432-BCD7-ABC3C96E8574},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:46,13/01/2011 14:01:46,0,0x,(null) PackageEnd,MY-SERVER,MY-DOMAIN\MY_USER,seantest2,{ED64B05A-F51B-4432-BCD7-ABC3C96E8574},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:46,13/01/2011 14:01:46,1,0x,End of package execution. E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:45,13/01/2011 14:01:45,-1073548540,0x,An error occurred with the following error message: "Access is denied". OnError,MY-SERVER,MY-DOMAIN\MY_USER,seantest2,{ED64B05A-F51B-4432-BCD7-ABC3C96E8574},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:45,13/01/2011 14:01:45,-1073548540,0x,An error occurred with the following error message: "Access is denied". OnProgress,MY-SERVER,MY-DOMAIN\MY_USER,unzip,{CF810406-12AA-4ED2-AE05-0938176A5BD0},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:46,13/01/2011 14:01:46,100,0x,Operation Complete OnTaskFailed,MY-SERVER,MY-DOMAIN\MY_USER,unzip,{CF810406-12AA-4ED2-AE05-0938176A5BD0},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:46,13/01/2011 14:01:46,0,0x,(null) OnPostExecute,MY-SERVER,MY-DOMAIN\MY_USER,unzip,{CF810406-12AA-4ED2-AE05-0938176A5BD0},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:46,13/01/2011 14:01:46,0,0x,(null) OnWarning,MY-SERVER,MY-DOMAIN\MY_USER,seantest2,{ED64B05A-F51B-4432-BCD7-ABC3C96E8574},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:46,13/01/2011 14:01:46,-2147381246,0x,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. OnPostExecute,MY-SERVER,MY-DOMAIN\MY_USER,seantest2,{ED64B05A-F51B-4432-BCD7-ABC3C96E8574},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:46,13/01/2011 14:01:46,0,0x,(null) PackageEnd,MY-SERVER,MY-DOMAIN\MY_USER,seantest2,{ED64B05A-F51B-4432-BCD7-ABC3C96E8574},{F025FABD-E99B-4CF6-9DE4-666BB599DA3B},13/01/2011 14:01:46,13/01/2011 14:01:46,1,0x,End of package execution. SeanSean

I've tried taking the cluster offline and rebooting the server, I've also failed over to another cluster, but the problem remains, I'm going to change all the unc \\servername\sharename, references to local paths on the server the package is running on.Sean

Hi, I found my answer on a previous question, supplied by yourself, thanks. add \\MyUNCPathtoServer (whatever you have in the UNC) to the Local Intranet sites zone in IE on the server and also make sure the "launching applications and unsafe files" option is enabled in the custom settings for the Local Intranet zone in IE. It it not directly SSIS related, but a security setting possibly interfering with the SSIS job Sean