Scenario

You have a huge amount of files in a file system folder and you need to move the new or modified files to another location. This example could be applied to several other scenarios, like reading data for some specific file (depending on file attributes) and in spite of using File System Task, you use a Data Flow task.

The source and destination folders are set dynamically, through SSIS variables. It’s also assumed that new files are those between current date and current date less n days (n days is a variable that could be 2 or more days)

Purposed solution

One possible solution is to use the for each loop task to pick each file in a specific filesystem folder and check the respective attributes of each within a script task.

Read the entire StepByStep example in the attached document below.

Reference: SSIS_EX_02_FELC