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 |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2008-03-25 : 15:49:00
|
| I am still in the process of finding out the best way to do this. The reason I still post the problem here as I know that many experts are still in this forum and maybe can help locate and solve my problem. Thanking you guys in advance!I have a folder which has around 2500 zip files. Those individual zip files contain same set of files within and they differ by name. Actually they are the data for 2500 different stores. I want to unzip them into a different parent folder. I would like to unzip them into subfolder inside the parent folder and the name of the subfolder should be that of the zip file (without the .zip extn).The batch utility should loop itself in the source folder, unzip all the zip files into the destination folder under the subfolder in the zip file's name. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-03-25 : 16:18:34
|
Use SSIS.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-03-25 : 16:43:15
|
| Appreciate if you could give me a jump start on the transformations to use and the flow of the process. |
|
|
|
|
|
|
Unzipping folders