• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1045
  • Last Modified:

DTS Lookup Error - Could not find server '' in sysservers.

Error Source : Microsoft OLE DB Provider for SQL Server

Error Description : Could not find server '' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

I am getting this error when I try and create a lookup for a data transformation in a DTS package. The lookup is needed on the local server. At a point in the past this machine has been renamed, which may have caused the problem, and if I had more time I would rebuild the system as it needs it anyway. However, it is not possible now and I need to have this DTS package created and tested ASAP.

Whats causing the error, how do I solve it so that I can create a Lookup on the local machine. Currently I can make the lookup, and it works ok, but this error does not bode well for future performance.

Cheers
0
sshelton2
Asked:
sshelton2
  • 3
  • 2
1 Solution
 
ranjit_jeromeCommented:
Hi

You need to add the server name in master..sysservers.  Use sp_addserver

sp_addserver 'servername', 'local'
0
 
sshelton2Author Commented:
And how do I run that - Command prompt or Stored Procedure?

Sorry - low level is not normally my residence in SQL Server...
0
 
ranjit_jeromeCommented:
Use query analyzer, this is a one time setting to correct the sysserver entry to recogzine your server.
0
 
sshelton2Author Commented:
Bang on, thats killed the error off and solved the problem. All tables are populating as it should, thanks.
0
 
ranjit_jeromeCommented:
No problem :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now