ChrisM@Work (8/28/2014)

---

Welsh Corgi (8/28/2014)

---

ChrisM@Work (8/28/2014)

---

Welsh Corgi (8/28/2014)

---

The example that I provided is not actually what I need. I want the Insert columns to be all from the Oracle Table.

Any ideas would be greatly appreciated.

Remove the join and the WHERE clause.

I do not get the reason for SELECT Distinct?

There may be duplicates across the columns selected from the remote. DISTINCT will eliminate those duplicates. Unless the count of such dupes is of interest to you, it makes sense to do this. In any case, it would be more network-efficient to count any dupes at source.