Unzip in SSIS
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....
October 15th, 2008 1:39am
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.
Free Windows Admin Tool Kit Click here and download it now
October 15th, 2008 6:34am
You'd call a command line unzip utility (like 7zip, or pkZip) from the Execute Process task.
October 15th, 2008 6:39am
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
Free Windows Admin Tool Kit Click here and download it now
October 15th, 2008 7:13am
hi therefor bunch of file use for each loop container and then loop through file name and unzip them
October 15th, 2008 1:14pm
yes but i dont know what command to use to unzip them....
Free Windows Admin Tool Kit Click here and download it now
October 15th, 2008 1:18pm
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
October 15th, 2008 2:56pm
The easiest option is to use Zip Task. The user interface is very simple and very well integrated in the SSIS framework.
Free Windows Admin Tool Kit Click here and download it now
October 15th, 2008 3:31pm
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
October 15th, 2008 3:43pm
Thanks logtorahul. that worked
Free Windows Admin Tool Kit Click here and download it now
October 15th, 2008 7:13pm
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.
October 15th, 2008 8:01pm
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
Free Windows Admin Tool Kit Click here and download it now
April 1st, 2009 9:51pm
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...
April 1st, 2009 10:55pm
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).
Free Windows Admin Tool Kit Click here and download it now
January 4th, 2011 4:46pm