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.
| Author |
Topic |
|
sgandhi
Posting Yak Master
115 Posts |
 Posted - 2009-03-31 : 06:49:18
|
| Hi, how do i unzip files looping through all files in a folder.I know i need to create a for each loop container and for each file enumeration assign a value to a new variable (Filewejustfound)Then inside the container put a execute process task.How do i set up this task |
|
|
sgandhi
Posting Yak Master
115 Posts |
Posted - 2009-03-31 : 11:09:35
|
| I think my problem is the when it takes the input file from the loop, the path is c:\documents and settings\ ....how do i put double quotes around this. When i ran this is get Invalid File name c:\documents.zipI think its picking up the file path rather than the name. |
 |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2009-03-31 : 12:30:47
|
| Try putting the zip in a different location such C:\temp\documents.zip. It might breaking the folder link with space on the name. |
|
|
|
sgandhi
Posting Yak Master
115 Posts |
Posted - 2009-03-31 : 12:59:40
|
| Thanks that worked, although i didnt want to do that, but i guess its probably the best thing to do in this situation |
|
|
|
sgandhi
Posting Yak Master
115 Posts |
Posted - 2009-04-01 : 10:42:17
|
quote:
Originally posted by sgandhi
Thanks that worked, although i didnt want to do that, but i guess its probably the best thing to do in this situation
One more thing. How do i make it do a fastest unzip? |
|
|
|
sgandhi
Posting Yak Master
115 Posts |
Posted - 2009-04-01 : 11:57:18
|
| Somebody please help. I found that i need to put -es or something but where do i put this. I want it to uncompress super fast. Please help this is urgent |
|
|
|
sgandhi
Posting Yak Master
115 Posts |
Posted - 2009-04-02 : 08:59:47
|
| Please helpI need to loop around a group of filesxml.gz and unzip them to another location.I have set a variable in the foreach loop container to filewejustfoundwhat do i put in the arguments section of the execute process task. I need it to unzip as fast as possible.I really need a solution to this |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
|
|
|
|
|
URGENT - Unzip file using execute process task