ramana3327 (4/30/2015)

---

Hi,

I have a table in Server A and it has 5 columns. One is Address & ID, CreateDatetime,..

I need to transfer data from this table from Server A to server B for a report pupose. The Address column in this table has some places two address in the table. I am giving ex below

Address

Houston, Dallas

Redmond

Sacramento

New Jersey, New York

I want to avoid the rows where address are two Houston, Dallas & New Jersey, NewYork to the destination table in server B and need to do incremental loads.

Any idea how to proceed with this?

The version we are using is Sql Server standard edition 2008r2