SSIS - Need to sort the most recent files and move them to new directory

• Naren-274001

  Ten Centuries

  Points: 1033

  More actions

  April 8, 2011 at 4:06 am

  #249114

  Hi,

  We are having daily loaded files in a server and we need to load those daily increment files to DB.

  The file format is

  *****20110227.txt

  *****20110228.txt

  *****20110228.txt

  These files are located at another server and we do have rights to copy files. The package executes fine for the first time. But the other day we will be having newly added files and we need to control the package to consider only the most recent files i.e...

  *****20110227.txt

  *****20110228.txt

  *****20110228.txt

  *****20110301.txt

  *****20110302.txt

  *****20110303.txt

  We need to ignore the files which were already loaded and need to consider the most recent files in sequential order.

  Can you please suggest a best approach for handling this.

  Thanks,

  Naru

• Russel Loski

  SSCertifiable

  Points: 7059

  More actions

  April 8, 2011 at 3:30 pm

  #1309457

  How do you identify files that have already been loaded?

  Russel Loski, MCSE Business Intelligence, Data Platform