Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Unzipping files from SSIS

Author  Topic 

kunaaldesai
Starting Member

36 Posts

Posted - 2009-10-29 : 00:24:15
I want to unzip files using SSIS package:

I have browsed many blogs before asking this question. I have little blurred picture of what I am supposed to do.

1.Use executable process task.
1.1 In process pan select the application name which I want to use in "Executables" option.
1.2 In argument pass the File name.



Now, what?

I came across some discussions which talk about passing command line? How does that work? do I have to write some script in C#? If I do write it then how to I pass that script to SSIS?

Is there any particular guidance on how to write this script?

Where do I specify the folder where the extracted items are going to be launched??


If it can be done exclusively by SSIS without including script then that would be my first preference.

I am not sure how the whole thing is going to work.

Ca somebody please guide me?

Anything

gaauspawcscwcj
Starting Member

29 Posts

Posted - 2009-10-29 : 06:36:44
u can use TaskUnZip like link below

http://taskunzip.codeplex.com/

gaauspawcscwcj
Go to Top of Page

kunaaldesai
Starting Member

36 Posts

Posted - 2009-10-29 : 13:29:37
Oh yes, thank you very much for the link, that seems to be helpful.

Anything
Go to Top of Page

kunaaldesai
Starting Member

36 Posts

Posted - 2009-11-03 : 14:20:14
hey,
I actually loaded TaskUnizp but I ma facing some problems while using it, do you have any previous experience with this particular tool? If yes then please let me know I just want some guidance.

Anything
Go to Top of Page

gaauspawcscwcj
Starting Member

29 Posts

Posted - 2009-11-06 : 03:05:05
whats u problems when u using it???

gaauspawcscwcj
Go to Top of Page
   

- Advertisement -