I am new in using SQL and DTS, I need help from experts. I want to copy data from ServerA to ServerB using DTS. ServerA has EMPLOYESS tables (EMP_ID, EMP_NAME, JOB_ID), ServerB have EMPLOYESS talbe and JOB talbe(JOB_ID, JOB_NAME).
Now I want to copy data from serverA.EMPLOYEES table to serverb.EMPLOYEES table if serverA.EMPLOYEES.job_id=serverB.JOB.job_id.
Now I know it sounds cofusing, but bascially I just want to know if I can query two tables from two different db servers in DTS?
Thanks