SSIS FTP transfer date and timestamp filename

[mahi2016]

Hello,

I have an ssis package with filename format as xxxxx_201605020937 (date and timestamp). There will be 2 files on Friday with same format but different timestamp. A job agent is set up to process these files on Saturday morning 1:00am.

I am looking for a solution to fetch these files which are loaded few seconds apart from FTP.

Thanks
MSN

 

[jjefferson]

Create a ForEach Loop Container. Set your "collection" property to xxxxx_.* Then put all your processing within this container. It will pick up each file matching the collection pattern and put it through the tasks.