Steps to get files as per the file name

Hi Team,

I have a source location where I have files as per the screenshot. (Capture1.jpg)

Now I need to prepare SSIS package import export to fetch this file based on the file name.

The logic should be for package 1 it should check date(20220425) and file name (_Cof_Test) and proceed for import.
For package 2 it should check date(20220425) and file name (_Dop_Test) and proceed for import.

I have made 2 packages but unable to fetch the file name dynamically. As of now I hard coded it. Please suggest how to pick the files for each packages.

Please refer the screenshot of the packages.(Capture2.jpg )

Have you considered using Advanced ETL Processor enterprise instead of SSIS?

index.php?option=com_content&view=article&id=252

It is much more flexible

Hi Mike,
In my organization I don't have access to use it. What I required is inside the Data Flow Task Source connection instead of picking the files manually I want to dynamically select the file by checking date(20220425) and file name (_Cof_Test) . PLease suggest.

Regards,