ReportDr00
IS-IT--Management
Hi,
In my dataflow task, i have source i.e sql server and lookup transformation and desitnation i.e sql server.
Based on Look up transformation if lookup does not find a record in reference table then insert new record into reference table and if lookup find record in reference table then update the record in reference table.
Here the reference table in lookup transformation will be the same that i will be inserting or updating the records.
Inserting new records is not a problem but how would i update the existing record easily?
Thanks
Armani