How to compare two tables on two different servers, in SSIS within one
package
I need to compare two tables on two different servers. Could someone help
me ? Easily I need get rows from two tables (based on same keys), which
exists into first table and not exist in second table(based on binary
checksum(hashKey)). After that I need to load them into stage table.
server1.database1.table1.HashKey<>server2.database2.table2.HashKey2 -->
this rows I need to received and insert them to table.
Thank in advance
No comments:
Post a Comment