CODEWITHSUNDEEP
ssis
QAIS
QAIS

Reputation: 149

SSIS synchronize two tables using lookup

I want to synchronize two tables src,dest(DB SOURCE>> src table, DB Destination>> dest table) using ssis, where any (insert, update and delete operations on src will be applied to dest) How can I achieve this using lookup tranformation ? Thanks in advance.

Upvotes: 0

Views: 509

Answers (1)

Vikramsinh Shinde
Vikramsinh Shinde

Reputation: 2878

Take table Dest in the lookup cache and then you need to lookup with Table Src .Choose option of the lookup as Redirect the non matching records. For the non matching records(not present in Table Dest) which are present in Table Src use OLE DB Destination to insert them in Table Dest.

For matching record use a physical table or temp table, use Execute SQl Task after the DFT to update those records in Table Src.

To speed up process try to use Cache Transform

Also you can achieve same by using Merge by following this article, Synchronize two tables using SSIS

Upvotes: 1

Related Questions