ForEach file Loop sorting options

• Neil-222145

  Old Hand

  Points: 397

  More actions

  March 30, 2007 at 9:26 am

  #116544

  I have an SSIS package that uses the ForEach File loop feature which does process each file in the specific directory, however there are no sorting options, therefore how can I ensure that the files found to be processed are processed in the desired order? such as by createdate and not by name?

  TIA

  Neil.

• Frank Bazan

  SSCertifiable

  Points: 5378

  More actions

  April 3, 2007 at 6:28 am

  #698260

  I guess you would need to include the following tasks:-

  1. You could use the foreach container to populate a table with filenames and properties.
  2. Then sort this table in the order you want and write results to a recordset.
  3. Loop through the recordset instead.

  Not as easy as it sounds I know, but I can't think of another way.

  Kindest Regards,

  Frank Bazan