How to Unzip the file Using script task

• MMartin1

  One Orange Chip

  Points: 27840

  More actions

  July 22, 2010 at 12:29 am

  #1196644

  Exexute Process task,

  you state the likes of the working directory and type a command as you would in a CMD window. The command is specific to the app you are using, say for example Winzip (which does cost $$ for a license).

  Best

  ----------------------------------------------------

• steve block

  SSCertifiable

  Points: 7698

  More actions

  July 23, 2010 at 8:17 am

  #1197536

  I've also downloaded 7-zip and plan to try it out using the command line interface. It supports 24 different formats including, zip, gzip, tar, rar, cab and z.

  Steve

• lijnenjoost

  Right there with Babe

  Points: 767

  More actions

  January 5, 2011 at 3:00 am

  #1269368

  Here is an example of a script task that unzips zip files:

  http://microsoft-ssis.blogspot.com/2011/01/unzip-files-with-ssis.html

  It's a simple C# script, so if you translate it to VB, it will work for 2005 as well.