Import data from a recent file into a folder

  • 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.

  • 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.


    Jason Yousef

  • Thanks a lot! This solution resolved my issue.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply