August 20, 2010 at 3:45 pm
Hello Everyone
I am playing around with SSIS while things are slow.
How can I read thru many files in a directory, I want to get the file timestamp for files of a certain extension, and then copy those files that qualify.
I am using C# and SSIS. I am trying to use the script task, but there is something that I am missing with it.
Thanks in advance
Andrew SQLDBA
August 22, 2010 at 9:07 pm
You could use a script task to check the last updated date of the file, and use a precedence constraint with an expression to either skip the file or process it based on that date.
See the attached file for an example of how to do this. I've got a blog post that will be published tomorrow that goes into detail on how to do this.
Hope this helps...
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply