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 |
|
dr223
Constraint Violating Yak Guru
444 Posts |
 Posted - 2011-07-20 : 05:50:24
|
| Hi, I have a folder in the server C:\Collections. The folder has zipped files. I would like to unzip the files in the folder. How will be the best way of doing.. Please note: files will be loaded to the folder on a daily basis. Thank you |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-20 : 06:27:48
|
| you can use ssis for unzipping. You need to add a script task and use j# library functions to do unzip.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
dr223
Constraint Violating Yak Guru
444 Posts |
Posted - 2011-07-20 : 08:18:08
|
| Ok, Followed the procedure as to the link belowhttp://sqlserversolutions.blogspot.com/2008/10/zip-and-unzip-files-in-folder.htmlWhen I executed the SSIS I received th error [Execute Process Task] Progress: Operation Complete - 0 percent complete[Execute Process Task] Error: In Executing "C:\Program Files\Info-Zip\unzip.exe" " e -oc:\Collections" at "", The process exit code was "9" while the expected was "0". [Execute Process Task] Progress: Operation Complete - 100 percent completeTask Execute Process Task failedFinished, 13:09:40, Elapsed time: 00:00:00.094What caused the package to FAIL ?Many thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-20 : 08:24:53
|
| is package executed from server where winzip was installed?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Unzip Folder