When you deal with SQL Server tables you would want to use stored procedures. DTS is for imort/export. For the sample code you posted you don't need neither one. When seek finds table1.id in the Table2 the table1.id is already equal table2.id.

> I need some serious help. I need to write a dts package that would loop through table1 seek id in table2 and if found replace values in table1. Here is an example:
>(table1 and table2 are sql 2000 tables)

>select table1
>scan
>   if seek(id,"Table2")
>      replace table1.id with table2.id
>      .
>      .
>      .
>   endif
>endscan

> I am a vfp programmer with no expierence in creating dts packages. Can someone please help me how can to accomplish the task of creating this dts package? Should I use store procedure, I am not even sure dts package is the right answer. What do I need to do?