We help IT Professionals succeed at work.
Get Started

DTS - Linked Server Query in Transformation Task Fails

394 Views
Last Modified: 2013-11-30
Hello, I'm moving a DTS package from one server (where it works, 2k box) to a second server which is a 2k5 box. A transformation task within the package has a query involving a linked server, which is also set up on the new server. The query works from a Query window but fails in the package with the following error:

Could not find server 'LAW' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.

LAW linked server exists in the  sys.servers of the 2nd server, and as I said, the query works from a query window on the 2nd server as well. Not sure what's going on or where to look next. Help!!
Comment
Watch Question
CERTIFIED EXPERT
Top Expert 2012
Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE