Hi All,

I'm new to DTS and am stuck. I have data in a free Fox table and am importing into a SQL7 table. The import works fine, except sometimes there is data in the Fox table that is a duplicate of what was already imported. Not the whole table, just some records.

If this was T-Sql I'd write something like

INSERT INTO Dest
SELECT Src.Fields FROM Src
WHERE NOT EXISTS (SELECT * FROM Dest WHERE Dest.Field1 = Src.Field1 AND Dest.Field2 = Src.Field2)

With DTS, I'm not sure how to accomplish this.
Any ideas welcome!
TIA,