How to create a command line for winzip command tool in SSIS that can be used to archive file.

• atsituab

  SSC Enthusiast

  Points: 122

  More actions

  April 10, 2008 at 12:48 am

  #205257

  Hello,

  I would like to have codes and the illustration of steps to do in order to create a command line tools in SSIS which can be used to archive file.

  Thanks,

  Mark

• Ulrich Bauhofer

  Say Hey Kid

  Points: 700

  More actions

  April 11, 2008 at 1:56 am

  #801328

  Hello,

  create an 'execute process task'.

  In Process / Executeable insert the execute (...winzip.exe )

  In Expressions select the property Arguments. Here you insert

  "-a -ex zipfile.zip examplefile".

  A better approach is to work with variables for zipfile.zip and examplefile i.e.

  "-a -ex " + @[user::zipfile] + " " + @[user::file]

• SQLArnold

  SSCommitted

  Points: 1847

  More actions

  April 8, 2014 at 2:51 pm

  #1704313

  This expression will work with spaces in the folder location.

  "-min -m -en " + "\"" + @[User::UnZipFileName] + ".ZIP \"" + "\"" + @[User::UnZipFileName] + "\""

  The pain of Discipline is far better than the pain of Regret!