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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-13 : 08:42:25
|
| Erik writes "Hello Team.I am trying to import a flat file (something.dat) into an existing SQL Server table. Basically, I would like the table to be emptyied and then filled with the content of the file.Using the wizard, I am able to import the file properly except that it will not let me import into an existing table but insists on creating a new table.After choosing the destination, server and database, I get the following error message:Error Description: Unspecified errorCould not find server 'name of my database' in sysservers.Execute sp_addlinkedserver to add server to sysservers.Context: Error calling GetRowset to get DBSCHEMA_TABLES schema info.Your Provider does not support all the chema rowsets required by DTS.I did add my database to sysservers but got the same error afterwards.I am using the latest trial version of SQL Server.Any ideas?" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-01-13 : 16:49:31
|
| I think you're confusing a couple of issues here. First of all, you seem to be mixing up database and server. In the wizard, it asks for the source and destination servers, and on those same pages, if you've selected a SQL Server such as (local) it will prompt you for login information and give you a drop-list of databases to choose from. One server in SQL Server contains multiple databases. Do not put your database name into the sysservers table.Then, once you get to the next sections where you select tables to be copied, and where to put them, the screen that shows destinations has another drop-down list where you can pick existing tables. If the fields don't match up exactly, you might have to go into the transform section to edit the mapping.------------------------------------------------------The more you know, the more you know you don't know. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-13 : 17:17:11
|
quote:
I did add my database to sysservers but got the same error afterwards.I am using the latest trial version of SQL Server.
I hope you didn't insert the record into sysservers by updating that table directly. Please say that you called the stored procedure to do it! |
|
|
|
|
|
|
|
|
Data Import Using Import Wizard