hi everyone, Can someone tell me how to do this in dts? I have 2 tables, source and target table. What I want to happen is pull data from source table then update a specific row in the target table. I can do this using regular sql as a job. But I would like to learn how I can do this using DTS. Thanks in advance!