Post reply

Import data from a recent file into a folder

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

  • 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

  • August 15, 2011 at 7:38 am

    #1368597

    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