I have an SSIS package that downloads some data from Oracle, then using the
Merge Join task I identify the new records and Insert them. My problem is
how do I Update the other records? My records from oracle are stored in
temp1 and the final destination table is T1. The joined fields are
temp1.col5 = T1.Col1 and temp1.col6 = T1.Col2. I tried using the Lookup
Task, where T1 was the reference table, but I don't see how to make the join
and how to map the fields to update. My other option is to write an Update
query, but that kind of defeats doing a Merger join Task. How are we
supposed to tackle this simple scenario? Thanks.