Foreach loop container SSIS

Question

I have a Foreachloop Container in my SSIS package under which a File system task is placed which moves files from Source Folder to the Destination folder and with that container, some other tasks are further connected.

Every time I run the package, all task starts running one by one despite having any new file in Source folder which always takes time.

Is there any way that if a new file added in Source folder then only all task run and if there is no file then only container run and package gets fail and show the message of No new file found through Script task?

Answer 1

You could store the names of the files that were loaded in a table and then use a script task to check if the files in the folder are present in that table and if any new file is found then execute the entire process