Hi all, Can anybody tell me how to unzipp a zipped file in SSIS. Ino you need to use Execute Process Task, but how would I go bout doing this? Thanks in advance....

Most file compression tools has command line options. You would need to figure out the command line to unzip your file(s) using the compression tool of choice, and then embed such comands and parameters in an Execute process task. Another option is to write some custome code inside of a script task to compress/uncompress the files.

Rafael Salas wrote: Most file compression tools has command line options. You would need to figure out the command line to unzip your file(s) using the compression tool of choice, and then embed such comands and parameters in an Execute process task. Another option is to write some custome code inside of a script task to compress/uncompress the files.A quick example, just in case:http://rafael-salas.blogspot.com/2008/10/ssis-compress-files-using-execute.html

Thanks, I have checked this out, but unsure what to put in as the command line (arguments option) to unzip a bunch of files?

hi therefor bunch of file use for each loop container and then loop through file name and unzip them

yes but i dont know what command to use to unzip them....

Mili_22 wrote: yes but i dont know what command to use to unzip them.... Pls go through the below link for an example...http://sqlserversolutions.blogspot.com/2008/10/zip-and-unzip-files-in-folder.html

The easiest option is to use Zip Task. The user interface is very simple and very well integrated in the SSIS framework.

Why dont you use SharpZip in Script task. Its open source and you can get the package from http://www.icsharpcode.net/OpenSource/SharpZipLib/ Thanks, Shujaat Siddiqi shujaatsiddiqi.blogspot.com

Thanks logtorahul. that worked

If you want all the files in a single zip file, then you don't have to use a foreach loop container, but rather use the appropiate command options. It would be worth to take a closer look at the command line capabilities of the archiver software being use, perhaps you could even generate individual zip file within a single command line.

If you want all the files in a single zip file, then you don't have to use a foreach loop container, but rather use the appropiate command options. It would be worth to take a closer look at the command line capabilities of the archiver software being use, perhaps you could even generate individual zip file within a single command line. Hi, i have followed this link and it works fine but the unzipping is a bit slow http://sqlserversolutions.blogspot.com/2008/10/zip-and-unzip-files-in-folder.html How do i set it so it unzips superfast

There are several Zip/Compression related tasks listed on the SSIS Community Tasks and Components project at CodePlex - some are free, some are for sale...

Here is an example to unzip ZIP files (not gzip) with a script task: http://microsoft-ssis.blogspot.com/2011/01/unzip-files-with-ssis.html It uses the Microsoft Visual J# Redistributable Packages (vjslib.dll).