SSIS Foreach File Enumerator Date Order

• JimS-Indy

  SSCarpal Tunnel

  Points: 4514

  More actions

  December 12, 2013 at 9:10 am

  #281198

  I'd like to ensure that my SSIS (2012) Foreach File Enumerator processes the files in order of creation date. Ideas?

  Jim

• Igor Micev

  SSC-Dedicated

  Points: 33110

  More actions

  December 12, 2013 at 10:20 am

  #1673023

  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

• Sifiso W. Ndlovu

  SSC Enthusiast

  Points: 151

  More actions

  August 3, 2017 at 12:45 pm

  #1954033

  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/

• mark 59108

  Newbie

  Points: 7

  More actions

  November 28, 2017 at 11:59 am

  #1969782

  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