Hi
I have a requirement like, i need to save all the records from my Flat File on Monthly basis to my database table. In the next month, the flat file may be added with 10-20 records and also some updates happened to my old records. Though the faltfile is same for each month, the changes are occured in some records and also added with few records.
So when i am loading this data in to Database table, i need to just update the changed records and also needs to add the new records. I don't need to touch the remaining records.
How can i do that in SSIS 2005 using different data flow tasks ?
Thanks
Kumaran
Answers are right here: http://www.sqlis.com/default.aspx?311
-Jamie
|||Hi Jamie
As per the URL you mentioned, i tried for the results.
I don't have any problem on identifying new records and inseting in to my database table using the "Conditional Split transformation".
But How to handle my few UPDATED records ? hoc can i identify that and update only those records in to my data base Table.
Thanks
Kumaran
|||You could use another lookup on the records that find a match which basically does the same - but looks up against ALL columns in the target. If there are any rows that don't find a match then you know something has been changed.
-Jamie
No comments:
Post a Comment