Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

compare flatFileName before process it Expand / Collapse
Author
Message
Posted Friday, December 18, 2009 12:38 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, December 30, 2010 7:19 AM
Points: 246, Visits: 502
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?


  Post Attachments 
SSIS.JPG (5 views, 63.94 KB)
Post #836586
Posted Friday, December 18, 2009 2:52 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 10:01 AM
Points: 10,282, Visits: 13,266
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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #836667
Posted Monday, December 21, 2009 1:52 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, December 30, 2010 7:19 AM
Points: 246, Visits: 502
I got the solution for this particular case.

Anybody is interested?
Post #837556
Posted Monday, December 21, 2009 1:59 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 10:01 AM
Points: 10,282, Visits: 13,266
Yes, please post solution. Thanks,




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #837567
Posted Monday, December 21, 2009 2:18 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, December 30, 2010 7:19 AM
Points: 246, Visits: 502
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,


  Post Attachments 
SSIS-Solution.doc (22 views, 55.00 KB)
Post #837580
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse