I created a DTS package to export data from a table in one database to a
table in another database located on another server. I got an error,
however, because the other database was not linked.

I went to query analyzer within the source database and tried:

exec sp_addlinkedserver 'ExternalServerName'

and then reran the package, which still failed. This time, I got the
following result:

Server: Msg 18452, Level 14, State 1, Line 1
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.

What did I do wrong? Thanks in advance for any help.

BH