Jim Horn
asked on
SSIS ForEach File Loop: How to determine most recent file in a folder
Hi guys
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.
Jim
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.
Jim
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.