How to stop the Winzip prompt showing when executing Exec process Task in SSIS

Question

Post reply

How to stop the Winzip prompt showing when executing Exec process Task in SSIS

dndaughtery

SSChampion

Points: 11290
More actions
January 6, 2016 at 7:39 am

#307431

I have the following values for the settings in the Exec Process task which is inside of a ForEach Loop task setting a file name to the current file for the ForLoop task:
Executable: C:\Program Files\WinZip\WINZIP64.EXE
Arguments: a "\\MyServer\MyFolder\MyZip.zip" "\\MyServer\MyFolder\"
The rest are at default values.
Every time I run it I get the WinZip Prompt with the following "Multiple files were dropped, an one or more is an archive. Add files to archive?
how can I set it up so that it just zips the files in that directory without prompting? The folder I have the ForEach working with has only .dat files in it and no .zip files.

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

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

Eric M Russell SSC Guru Points: 125562 More actions · Answer 1

For use in an Exec Process task, perhaps the DOS command version of WinZip would be more appropriate.

http://whitemarker.blogspot.com/2006/09/dos-using-winzip-for-command-line.html

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

dndaughtery SSChampion Points: 11290 More actions · Answer 2

I see that the post has

winzip32 [-min] action [options] filename[.zip] file(s)

I don't have WinZip32. Can I just substitute in WinZip64?

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 3

The official documentation is here:

http://kb.winzip.com/kb/entry/125/

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

Matt Miller (#4) (1/6/2016)
The official documentation is here:
http://kb.winzip.com/kb/entry/125/

Making it easier for others:

http://kb.winzip.com/kb/entry/125/

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 5

Thanks Lynn - my JavaScript is apparently disabled in office....

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?