Importing latest file in folderwith SSIS

• BKW

  Ten Centuries

  Points: 1350

  More actions

  September 3, 2008 at 3:42 pm

  #197796

  Anyone got a way to get the last excel file using SSIS? I currently have a job that gets the last file in a folder like: file003 dated 09/03/2008

  file002 dated 09/02/2008

  file001 dared 09/01/2008

  I need file003 to update table in DB.

  I used activeX in SQL2000 as DTS and tried to convert it but didn't like the way it did it and would like to do it cleaner in SSIS

  Changinagain

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  September 4, 2008 at 6:49 am

  #867084

  You may want to check out the File Properties Task custom component created by PragmaticWorks:

  http://www.pragmaticworks.com/FilePropertiesTask.htm

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question