Home Forums SQL Server 2005 Business Intelligence how to pick the first file first from specific folder using for each in SSIS RE: how to pick the first file first from specific folder using for each in SSIS

  • November 9, 2016 at 10:31 pm

    #1911533

    Jeff Moden (11/8/2016)

    drew.allen (11/8/2016)

    The files are processed in alphabetical order. If you follow the naming convention of having a fixed filename prefix with a timestamp suffix in YYYYMMDDHHMMSS order they will be processed in datetime order.

    Drew

    Yowch! Did not know that you couldn't interrogate file dates in SSIS.

    One can and it's easy using something like the FileInfo Class

    😎