Is it possible ? -- sql server dts

Jeff Mil
1/7/2004 6:03:05 AM

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.

Jeff Mil
1/7/2004 9:00:24 AM

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.

[quoted text, click to view]

Allan Mitchell
1/7/2004 3:14:24 PM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Is it possible ?