SSIS ForEach File Loop: How to determine most recent file in a folder
I have an SSIS 2012 package, with a ForEach loop that goes through a folder.
Question: Does anyone know how to pull of 'How to determine the file with the most recent 'Date Modified'? My source folder will contain a full-load file generated each day, and my task is to use the most recent file, and delete the rest. Thanks in advance.