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.

• Eric M Russell

  SSC Guru

  Points: 125596

  More actions

  January 6, 2016 at 7:59 am

  #1849850

  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

  January 6, 2016 at 8:14 am

  #1849860

  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

  January 6, 2016 at 9:06 am

  #1849899

  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

  January 6, 2016 at 10:38 am

  #1849947

  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

  January 6, 2016 at 12:10 pm

  #1849983

  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?