<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Data Warehousing
»
Integration Services
»
Unzip error through Excute process task
Unzip error through Excute process task
Rate Topic
Display Mode
Topic Options
Author
Message
quillis131
quillis131
Posted Tuesday, February 12, 2013 4:30 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 8:59 AM
Points: 156,
Visits: 514
"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
opc.three
opc.three
Posted Wednesday, February 13, 2013 8:31 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 1:24 PM
Points: 6,826,
Visits: 11,950
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
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1419568
quillis131
quillis131
Posted Wednesday, February 13, 2013 9:27 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 8:59 AM
Points: 156,
Visits: 514
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
opc.three
opc.three
Posted Wednesday, February 13, 2013 9:49 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 1:24 PM
Points: 6,826,
Visits: 11,950
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
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1419625
quillis131
quillis131
Posted Wednesday, February 13, 2013 10:16 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 8:59 AM
Points: 156,
Visits: 514
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
opc.three
opc.three
Posted Wednesday, February 13, 2013 11:06 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 1:24 PM
Points: 6,826,
Visits: 11,950
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
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1419662
quillis131
quillis131
Posted Wednesday, February 13, 2013 12:17 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 8:59 AM
Points: 156,
Visits: 514
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
opc.three
opc.three
Posted Wednesday, February 13, 2013 12:21 PM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 1:24 PM
Points: 6,826,
Visits: 11,950
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
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1419689
quillis131
quillis131
Posted Wednesday, February 13, 2013 12:28 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 8:59 AM
Points: 156,
Visits: 514
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
opc.three
opc.three
Posted Wednesday, February 13, 2013 12:31 PM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 1:24 PM
Points: 6,826,
Visits: 11,950
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
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1419701
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
