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?