"Could not find server 'tmviis1' in sysservers. Execute sp_addlinkedserver to add the server to sysservers."

No no...I don't want to add the server -- it doesn't exist. I want to change or remove wherever it is trying to use that old server name within the database.

how are you importing?

it seems that 'tmviis1' is hardcoded in the import script (if thats how you are doing it).

Find out where and change it to the new name.

It is no where in the script (just checked). All I did was go to "Import..." and put my source server, destination server, copy objects, selected everything except data (because of the BLOBs over 64k problem with import/export), and it gave me that error. I may need a little more detail in the responses because I'm pretty new to this. Thanks.

In the DTS import wizard..

on the last step before you press finish.
Does it say the correct "location" within the source and destination

can you try specifiying the IP of the live web server....maybe a WINS problem??

Both locations are fine, here's the summary before it runs:

========================================

Source: Microsoft SQL Server
Using Microsoft OLE DB Provider for SQL Server
Location: mis00004
Database: its2

Destination: Microsoft SQL Server
Using Microsoft OLE DB Provider for SQL Server
Location: MIS0020
Database: its2

Tables

========================================

It's for an intranet, so there's no public interface for it and, thus, no external IP. My thoughts are that something internal is trying to use that old name. Is there an error log that would be more specific to where the error originated?

internet uses DNS for name resolution

intranet uses WINS for name resolution.  There could be a problem there.

to bypass the WINS server you can specify the IP of MIS0020 rather than the name.  This will eliminate the possibility of there being a WINS problem

what happens if you ping MIS0020 ??? does it reply ok?

Yes, it pings fine. It's a problem w/ the old name. There is no more server called "tmviis1". I need to know where to find that in the old database so I can update it. Do you know where it could be or how I would find it?

If you are sure that the names are resolving correctly
Then there has to be a view or stored procedure that refers to tmviis1.  

ie) FROM tmviis1.its2..myTable

find which view/sp specifies the server and either change it, or remove it from the selected objects to copy

Right, is there any way to check thise aside from manually going into each and every one?

you could try this in query analyzer (with Query->Results in text turned on)

SELECT
    Definition = [text]
FROM
    syscomments
WHERE
    OBJECTPROPERTY(id, 'IsMsShipped') = 0
    AND OBJECTPROPERTY(id, 'IsView') = 1  ---isProcedure for sp
ORDER BY
    OBJECT_NAME(id)


then search the text for the file name

Yay, it worked! Your snippet even helped me find the next error that popped up :-P

A+ to you!