Extracting Zipped Folder From SSIS

Question

Hi, how to extract a zipped folder from SSIS...dat folder consists of 10 excel files and 8 text files..we need to load them to diff sql server destinations within a single package..how can i do dat? and i need to do dat with out using script task..can i use execute process task and for each container ?

Answer 1

Hi,

Please give the following links a try; -

http://ssisextensions.codeplex.com/

and

http://taskunzip.codeplex.com/

Kind Regards,

Kieran.

---

If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI,MCC, PGD SoftDev (Open), MBCS http://www.innovativebusinessintelligence.com/ http://uk.linkedin.com/in/kieranpatrickwood

Answer 2

Here is an other UnZip Task:

and some others:
http://www.cozyroc.com/ssis/zip-task
http://taskunzip.codeplex.com/
Other alternatives:
Execute Process Task in combination with Winzip commandline
Script task with opensource zip dll
Script task with System.IO.Compression (gzip)
Script task with Visual J# Redistributable Packages (zip)
example: http://microsoft-ssis.blogspot.com/2011/01/unzip-files-with-ssis.html

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter