Hi,<BR><BR>1) I want to insert data into a table which is in the remote database server from the database in my local system 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 DTC & SQL Serer Agent etc.<BR><BR>Please let me know the sample SQL syntax if the above task is acheivable.<BR><BR><BR>2) Is there any way in DTS to specify that it has to append only new data while importing data from one table to the same table in the remote database.<BR><BR>Thanks in advance,<BR><BR>Shyam.