Winzip use in SSIS

Question

Winzip use in SSIS

Brandie Tarvin

SSC Guru

Points: 173083
More actions
September 14, 2010 at 4:17 am

#145177

Sorta about SQL, Sorta not.
I have an Execute Process task in SSIS that calls Winzip. Every time I run the package, whether from BIDS on my desktop or SSMS -> Integration Services -> Run Package, Winzip pops open on my desk top.
I'm using Winzip 9. I thought I'd had the command line options (arguments) to keep Winzip from blatantly opening, but apparently not. Does anyone know the options for prevent this? Or not requiring user interaction?
It also keeps asking me to associate zip files with Winzip, even though it's associated them before. And it's using the Winzip executable on the server, not on my local box.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 1 through 15 (of 16 total)

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

Brandie

It's been a while, but i thought at one point only the registered version fo WinZip has command line options? or is it a seperate application that comes with the registered version?

I've been using 7zip (which is free) for quite a while now; it's been working fine for command line, xp_cmdshell and console-type applications i write;

take a look at that if you decide to switch.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Brandie Tarvin SSC Guru Points: 173083 More actions · Answer 2

The newest version of Winzip (11 or 12) has a separate utility for command line. But we're using an older version that didn't require it.

And I can't switch to 7zip unless corporate approves it. It's one of those "no unauthorized software" issues.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Steve Jones - SSC Editor SSC Guru Points: 736642 More actions · Answer 3

My guess is some registry / config item is looking to associate files with WinZip and wants clarification from you. If you associate the files with Winzip, does it stop?

WayneS SSC Guru Points: 95461 More actions · Answer 4

WinZip.exe is a GUI tool. Even way back when I was using WinZip 6, the command-line was a separate program.

The command-line tool is separate add-on. See http://www.winzip.com/prodpagecl.htm.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Brandie Tarvin SSC Guru Points: 173083 More actions · Answer 5

Thanks for the link, Wayne. I've already seen it, though. It doesn't help me because it requires Winzip 12.

I guess I need to talk to my license people.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

WayneS SSC Guru Points: 95461 More actions · Answer 6

I know I have a command-line version of WZ on one of my home computers... want me to look around for it?

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Brandie Tarvin SSC Guru Points: 173083 More actions · Answer 7

WayneS (9/14/2010)
I know I have a command-line version of WZ on one of my home computers... want me to look around for it?

That would be nice, but is it license free or license required?

My company is very strict about the whole pirated license issue. At least, my division is. Part of the company ethics policy and all that.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

WayneS SSC Guru Points: 95461 More actions · Answer 8

Brandie Tarvin (9/15/2010)
WayneS (9/14/2010)
I know I have a command-line version of WZ on one of my home computers... want me to look around for it?
That would be nice, but is it license free or license required?
My company is very strict about the whole pirated license issue. At least, my division is. Part of the company ethics policy and all that.

Okay, I'll look around for it. I haven't used it in a while. It looks like it is free.

Perhaps an email to WZ - let them know the version you have, and that you are interested in the command-line version for that?

The command-line version uses WZZIP and WZUNZIP. Look around - you might already have them. You can get some of the older versions on their Alternative Downloads and Legacy Download pages - just get the proper one for the version of WZ that you have.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Jeff Moden SSC Guru Points: 1004441 More actions · Answer 9

The command line version of Winzip is actually the PRO version of Winzip and it hasn't been free for a long time.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Brandie Tarvin SSC Guru Points: 173083 More actions · Answer 10

Jeff Moden (9/15/2010)
The command line version of Winzip is actually the PRO version of Winzip and it hasn't been free for a long time.

That's what I figured. On the other hand, Wayne's suggestion to check the already installed software is a good one. It might just be hiding (but installed) and I haven't found it yet.

Thanks, All.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Brandie Tarvin SSC Guru Points: 173083 More actions · Answer 11

Wayne, thank you for the name of the command line exe files. We do have them.

Unfortunately, when using it and running the pkg from my desktop, it still opens up the Winzip interface. So I must be doing something wrong.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

WayneS SSC Guru Points: 95461 More actions · Answer 12

You're sure you're running wzzip, and not winzip32?

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Brandie Tarvin SSC Guru Points: 173083 More actions · Answer 13

WayneS (9/16/2010)
You're sure you're running wzzip, and not winzip32?

I was running winzip32 originally. Now I'm running wzunzip (I'm extracting files). Is that the wrong .exe?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Igor Santos Mr or Mrs. 500 Points: 530 More actions · Answer 14

I use 7zip on my servers, it's free, it works on both, 32 and 64 bit platforms, has cmd line available to batch and it works like a charm.

May not be an option for you now, since the packages are probably already developed using WinZip commands, but keep that in mind.