I have to load data from a db2 source but before I am loading the data I need to check if I have the rows in my db (sql server) and load only the new rows. How can I do it in a data flow task? I don't want to load it to my db and then check...
I understood that I have to do it with merge join / lookup and then conditional split, the problem is that I can't understand how to do it when I have 2 (or more) fields that I have to check...
Please help.... 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply