December 18, 2009 at 12:38 pm
See attached file.
I have a Package that read the files located in a specific path, and then it will process some data flows (compare data and insert data into SQL Database).
Before to process every dataflow, I need to verify if the file that my package is reading in that moment (User::FileName) has been storage (processed) in my table.
I don’t find the way to do it, if you see in my SSIS attached file. I insert a log of the file processed. But I don’t know how to compare or what Control Flow to use.
Any advice?
December 18, 2009 at 2:52 pm
You could do something like what Tim Mitchell suggests in this blog post. Of course first you need to load the file names from the log table.
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
December 21, 2009 at 1:52 pm
I got the solution for this particular case.
Anybody is interested?
December 21, 2009 at 1:59 pm
Yes, please post solution. Thanks,
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
December 21, 2009 at 2:18 pm
See attach.
And image says more than a word
It was kind of hard to find out the answer. Even know its something easy, but I never use this before. I used Tim Mitchell recommendation as you suggested. But I didn’t know how to control the names that were inserted in my sql table.
So, take a look at the attach and see the Data Flow of the Control Flow called “Compare if File exists in Log Table”
Regards,
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply