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!!