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

Unzip error through Excute process task Expand / Collapse
Author
Message
Posted Tuesday, February 12, 2013 4:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:04 PM
Points: 162, Visits: 570
"Error Message :
your ID does not have sufficient privileges to install software. Also,winzip was not properly installed by user with adminstrative privileges.
Please contact your system admin and ask them to reintall Winzip"


I Pass in the
Executable: Location of WIN32.exe
Arguments : -e Location of zipfile
Working Directory : Destiantion directory.

I tried to go onto the Location of Zipfile and tried unzipping it manually and it all works good. I can't figure out what should be the issue, running it through execute process task.
Post #1419235
Posted Wednesday, February 13, 2013 8:31 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:32 AM
Points: 7,135, Visits: 12,745
Is the process running under your Windows security context when run through the Execute Process Task, i.e. through BIDS or SSDT, or is this error coming from an unattended process like an Agent job?

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1419568
Posted Wednesday, February 13, 2013 9:27 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:04 PM
Points: 162, Visits: 570
opc.three (2/13/2013)
Is the process running under your Windows security context when run through the Execute Process Task, i.e. through BIDS or SSDT, or is this error coming from an unattended process like an Agent job?


Through BIDS
Post #1419611
Posted Wednesday, February 13, 2013 9:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:32 AM
Points: 7,135, Visits: 12,745
64-bit workstation? Make sure your Project property Run64BitRuntime is False.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1419625
Posted Wednesday, February 13, 2013 10:16 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:04 PM
Points: 162, Visits: 570
opc.three (2/13/2013)
64-bit workstation? Make sure your Project property Run64BitRuntime is False.

Yes mine is 64 bit and I made sure Run64BitRuntime is False. It doesnt help
Post #1419645
Posted Wednesday, February 13, 2013 11:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:32 AM
Points: 7,135, Visits: 12,745
Just confirming that you can run Winzip from the command line directly, or did you mean when you run winzip that it was interatively?

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1419662
Posted Wednesday, February 13, 2013 12:17 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:04 PM
Points: 162, Visits: 570
opc.three (2/13/2013)
Just confirming that you can run Winzip from the command line directly, or did you mean when you run winzip that it was interatively?


I didn't get you.
All I was doing is running Winzip from Execute process Task. I was not running it through CMD.
Post #1419686
Posted Wednesday, February 13, 2013 12:21 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:32 AM
Points: 7,135, Visits: 12,745
You said in the original post:


I tried to go onto the Location of Zipfile and tried unzipping it manually and it all works good.


Was that just double-clicking on the file to open it interactively in Winzip or did you do that from the command line, using the same command line the Execute Process Task would issue? I am just trying to establish that it is working from the command line as a baseline so we know to focus on the Execute Process Task.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1419689
Posted Wednesday, February 13, 2013 12:28 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:04 PM
Points: 162, Visits: 570
opc.three (2/13/2013)
You said in the original post:


I tried to go onto the Location of Zipfile and tried unzipping it manually and it all works good.


Was that just double-clicking on the file to open it interactively in Winzip or did you do that from the command line, using the same command line the Execute Process Task would issue? I am just trying to establish that it is working from the command line as a baseline so we know to focus on the Execute Process Task.


Yes that was double clicking on the file and it worked.
Post #1419696
Posted Wednesday, February 13, 2013 12:31 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:32 AM
Points: 7,135, Visits: 12,745
OK. I should have confirmed that from the start. My bad.

Get a command line working first, then move over to configure the Execute Process Task.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1419701
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse