rt, Update, Delete records from destination table by comparing records in source table.
Update: if records exist in both the table compare them, and update value in destination table if value is different.
Insert: if record doesn't exist in destination table, add new record in destination table.
Delete: if record exist in destination table but not in source table, delete record from destination table.
----> I have created an SSIS package that does all this task but in order to perform delete operation, I have to store all records of destination table into a temporary table.
And since it's not the most efficient way, I have created another SSIS package by using Lookup & conditional Splits
method, now it works fine with inserting and updating information but I am not sure on how to handle removing record operation!
I would really appreciate if you could help me with this.
(In order to archive inserting and deleting records, I have referred following thread!
View Complete Post