I have a link server I'm trying to connect to in a DTS package.
I'm not sure what connection to use and how to set it up.
Any suggestions??

Hi,

"news.microsoft.com" wrote:
do you mean a linked server is defined on your SQL Server?
Generally DTS connects servers through dedicated connections and therefor
doesn't use your linked server.
So you can query the linked server in sql tasks as normal source.
Or you define a connection object for that server and specify your
connection parameters there.

Can you clearify your question?

Helge

Yes I mean linked server,
I was trying to use a connection is the DTS packages,
But it sounds like I have to write out the sql code in order to connect.

Thanks for your help.



"Helge C. Rutz" <news050424 (AT) nurfuerspam (DOT) de> wrote

Hi,
"news.microsoft.com" wrote:
if you rely on the linked server defined by someone else then you have to
use the full quallified four part source name or OPENQUERY, which could
maybee give better performance when used right.
When you do this, and want to schedule the package, you also have to take
care who is then executing the package and accessing the linked server, to
get the right user mapping.

HTH
Helge