December 12, 2013 at 9:10 am
I'd like to ensure that my SSIS (2012) Foreach File Enumerator processes the files in order of creation date. Ideas?
Jim
December 12, 2013 at 10:20 am
This should help you http://microsoft-ssis.blogspot.com/2011/04/how-to-configure-foreach-loop-container.html
Igor Micev,My blog: www.igormicev.com
August 3, 2017 at 12:45 pm
Consider using a Script task and sorting the files using methods from LINQ as per article https://www.sqlshack.com/using-ssis-foreach-loop-containers-process-files-date-order/
November 28, 2017 at 11:59 am
Consider using DirectoryInfo.EnumerateFiles in your script task instead of the above suggestions.
https://msdn.microsoft.com/en-us/library/dd413232(v=vs.110).aspx
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy