Import data from a recent file into a folder

• sreeya

  SSC Eights!

  Points: 979

  More actions

  August 11, 2011 at 9:14 pm

  #242127

  Hi All,

  I have been working on a package that retrieves data from a csv file and import data into a table. I would like to schedule it to run for every one hour. In this package, I want to add a condition such that it imports the data from file in a folder which was created/modifed within last one hour. Any ideas on accomplishing this would be greatly appreciated. Thanks.

• JasonYousef

  SSCommitted

  Points: 1769

  More actions

  August 12, 2011 at 8:27 am

  #1367964

  Hi,

  I've blogged your solution here

  Basically what you need is a "foreachloop" to iterate over your files, get the file creation date using a script task, use the precedence constraint to check if it's less than 60 minutes so you can process it.

  Let me know if you have any Questions.

  regards,

  Jason Yousef

• sreeya

  SSC Eights!

  Points: 979

  More actions

  August 15, 2011 at 7:38 am

  #1368597

  Thanks a lot! This solution resolved my issue.