How can I compare data in tableA on ServerA against tableB on ServerB and
insert/update data to tableB on ServerB based on success/fail conditions?

What tasks should be used and how?

Thank you.

Hello Terry,

You can use;

1. A Data Pump task along with lookups (slow)
2. Linked server. Issue TSQL
3. Pump the data over from A --> B and run TSQL statements against it.
4. use Red-Gate's SQL Data Compare.



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com