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.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.