March 25, 2008 at 1:13 pm
First of all, I want to inform that this particular problem was told to NOT use SSIS. I know, I hate it too, it would be easier if I could just do it by using SSIS. But I am still in the process; finding out the best way to do it. 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.
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
March 26, 2008 at 5:43 am
You are posting this in an SSIS forum.
If you want a non-SSIS solution, I suggest you post this in a forum related to batch files or .Net programming. This is fairly simple to do with a batch file, so that would be my suggestions for a direction to go in.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply