Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-20 : 09:20:02
|
| Shyam writes "Hi,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.Will i be able to do this from SQL Query Analyzer? Do i need to start the DTC & SQL Serer Agent etc.Please let me know the sample SQL syntax if the above task is acheivable.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.Thanks in advance,Shyam." |
|
|
|
|
|
SQL Server 2000