Â*<BR>Hi, <BR><BR>1) I want to insert data into a table which is in the remote database server from the table in the database that is in my local system (local copy of the database) through a SQL query. Please note that i have the remote server access and i am already using DTS for data transformations. <BR><BR>Will i be able to do this from SQL Query Analyzer? Do i need to start the Distributed Transaction coordinator (DTC) & SQL Serer Agent etc. <BR><BR>Please let me know the sample SQL syntax if the above task is acheivable. This will be really helpful.<BR><BR><BR>2) Is there any way in DTS to specify that it has to append only new and changed data/records while importing data from one table in the local server to the same table in the remote database. <BR><BR>Thanks in advance, <BR><BR>Shyam.