Home Forums Data Warehousing Integration Services SSIS Packge to locate the latest file with particle file name, unzip the file and import into a table RE: SSIS Packge to locate the latest file with particle file name, unzip the file and import into a table

  • Hello Aaron,

    Here are some more samples of the unzipped file names, it does appear the filename are alway the same length of 23.

    1 2

    123456901234567890123

    ANT591.PDERPDE0820002

    ANT591.PDERPDE0820001

    ANT591.PDERPDE0807001

    ANT591.PDERPDE0808001

    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?

    Thanks,

    Tim

    The pain of Discipline is far better than the pain of Regret!