I'm trying to create a DTS package that will be moving data from SQL
Server 7 to SQL Server 2K.

When I try to open the properties of a transform data task Enterprise
Manager just quits without notice.

If I try to create an Execute SQL Task against the source db, when I
click the Build Query button I get an "Invalid object name
'sysservers'" error, followed by a "Could not find server '' in
sysservers. Execute sp_addlinkedserver to add the server to sysservers".

Googling this error turned up two situations for it: database name (or
other object names) that contain periods. That is not the case here.
Second, one person mentioned checking the server name. Doing a SELECT
@@servername on the source DB returns the correct value; the server also
has an ID of 0 when you do an exec sp_helpserver.

The only db I can successfully connect to on the source is master. Pub
and Northwind return the same error.

A linked server is not required to use DTS, and I don't have it in place
for SQL 2K sources.

Any ideas? I can't believe that using DTS from 2K to 7 doesn't work.

Don