>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,

Are you using the DTS wizard or the DTS designer?

At some point in the wizard you will get asked if you want to transfer tables or if you want to use a query for the source. Here you select the query option and write the part that extracts the data from the source. In the subsequent steps you will specify where you want to put the resulting query.

If using the DTS designer things are not much different, only that you need to specify the connections and then create a transformation type task where you specify the source query, the destination query and the correspondence in a more manual fashion.