Can you please help me how to use "For each Loop" container to get "zip" files based on Date timestamp? Is there a way to do it using "Script Task" with C# ? Thanks for your help.

Hi Experts,

I need your help in creating a SSIS solution.

Here is task detail:

There is a Input folder which gets a "zip" file from the client with the date timestamp in this format "ABCYYYYMMDDHHMISS.zip". I have to get the zip file based on date timestamp, which means if the SSIS job is running today it should get the file with todays date timestamp. Then extract zip file and put all the text files to another folder. Then use the DFT to load the text files to the sql server tables. 

In the end move the zip file to the Archive folder.

I am able to do most of the the things described above but I am stuck at one place.

I am using the "For Each Loop" container to get the zip files. It works fine when I use file name = "*.zip" but I want it search based on the datetime stamp. I do not know how to do it. I tried to use an Expression but it did not work.