Here are some more samples of the unzipped file names, it does appear the filename are alway the same length of 23.
I am not sure what you mean, I have been able to locate the zipped file and unzip it but the zipped filename and the unzipped filenames are not the same. Maybe I misunderstood, can you explain, please?
I have been figuring out that (WinZip) zipping through SSIS is a difficult task. I am also trying to free up some space in a folder that has 300+ files. I would like to have a foreach loop locate each file, zip it then move to the next unzipped file. I keep getting error messages, "No files were found for this operation - Nothing to do" or "Cannot open file: it does not appear to be a valid archive.
I am using a foreach loop to locate the file name passing the filename inside the foreach loop to excute process task with arguments expression "-min -a -en " + @[User::flatFileName] or have tried "-min -m -en " + @[User::flatFileName]. Any ideas whereI could more information?
The pain of Discipline is far better than the pain of Regret!