September 4, 2008 at 8:17 am
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
September 5, 2008 at 8:32 pm
I'd create an archive folder and then use a foreach loop using the for each file enumerator. Process the file and then move it to the archive folder using the File System Task.
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
May 21, 2010 at 9:58 am
Hi Jack,
I am having the same issue as BKW where i have to monitor a Folder where user drop the EXECL file and my SSIS package run. But what i need is similar to BKW where i need to grab latest file dropped,
Is there a way in ssis where we can do this?
Please advice,.
May 21, 2010 at 10:10 am
I already offered how I would go about handling this. Another option is to use a third party-component like the FileProperties task by Pragmatic Works (free) or the FileProperties task by Todd McDermid on codeplex.
You'd still need the for each loop to iterate over the files and then check the created date, I assume, and process the file with the most recent date. Not sure how it would work exactly, but I'm sure you could figure it out.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply