I have to pull in some data from a huge table on another server. I have a
local table containing the acctnumbers I need. But, I cannot figure out a
way to bring in only the records having an acctnumber in the local table. I
have tried to configure a lookup, but that doesn't work to filter the
incoming records. If I try to bring in all the records and then filter them,
it would be a huge undertaking. The two servers aren't linked and I have
trusted connections to each. What can I do?

You could of course send the "Filtering table" to the large table destination and do it that way
OR
Look at Linked Servers

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"database_princess" <databaseprincess (AT) discussions (DOT) microsoft.com> wrote

I assume you meant to send the small filtering table to the server/db where
the large table resides, but I only have read access to that source
server/db. I tried to use oledb, but since it is trusted, it wouldn't work
because you have to have a login and password. I tried running the stored
proc to add the linked server, and I see it when I run sp_linkedservers, but
it doesn't seem to change anything as far as my being able to reference both
servers in a query. Is there some special syntax to this, because I cannot
get it to work....

"Allan Mitchell" wrote: