Hi,

Do you know if it's possible to execute a sql query like
this in DTS :
Insert Into Connection1.Table1 _
Select * FROM Connection2.Table1 WHERE _
Connection1.Table1.Field1 Not In _
(Select Connection2.Table1.Field1 FROM _
Connection2.Table1)

So i have same tables in different database server. I want
to insert new field from Connection2.Table1 into
Connection1.Table1.

Please help me or tell me if its possible in sql server 2k.

Thanks.

Nope not possible at least not like that anyway.

You will have to workaround this by either

1. Using linked server
2. DTSing over the Connection2.table1 over to Connection1 and then use TSQL
to do the INSERT.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Jeff Mil" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thank's for your response.
So I've made a W2K service with VB 6.0 and a simple Access
database so I could synchronize my table with a simple
query.

Thank's and have a good year 2K4.