I'm trying to create a DTS to simulate the following - because of security I
cannot use linked servers - however I am allowed to query the servers via
DTS.

If I was allowed a linked server - my TSQL may look like this:

Select myVal
from server1.win.dbo.encase
where MyVal not in (select myVal from server2.win.dbo.encase)

My approach was:
-create two SQL connections, one to server1 and server2
-create a Execute SQL task to server one to retrieve a gvRS of MyVal from
Server1
-create a 2nd Execute SQL taks to return MyVal numbers from Server2 that
don't exist in the gvRS

You can use Openrowset to the other data source instead of
linked servers. So the where clause would be something like:
WHEREMyVal not in
(SELECT *
FROM Openrowset('SQLOLEDB','server2';'user';'password',
'SELECT myVal FROM Encase'))

You may also want to consider using not exists instead of
not in.

-Sue

On Thu, 3 Feb 2005 11:16:32 -0800, "news.microsoft.com"
<joe (AT) msn (DOT) com> wrote: