Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DTS Import Wizard question

Author  Topic 

kensai
Posting Yak Master

172 Posts

Posted - 2002-10-02 : 17:14:53
Hello. I'm getting an error when I try to use DTS Import Wizard. I'm gettint this error both when I try to import data from a Access file or between two SQL Servers. I couldn't figured out what to do, I'd be glad if you can help me:

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

Context: Error calling GetRowset to get DBSCHEMA_TABLES schema info. Your provider does not support all the schema rowsets required by DTS


What should I do for this?

   

- Advertisement -