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

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Urgent: can't copy data between two databases/ DTS

Author  Topic 

Starting Member

2 Posts

Posted - 2003-04-10 : 06:35:20
I am trying to upload data from one database to another and now, the whole process is failing. I am using SQL Server 2K and this worked last week.

When I use the DTS wizard to import data, I get the error:
[Microsoft][ODBC SQL Server Driver][SQL Server] The login '[x]' does not exist.

X would be the login on the what side? I don't know. However, I tested it with a separate set of databases between my server here and another server and it worked. I think it's the login for the copying data from server, but that exists.

I need help on this bad


12543 Posts

Posted - 2003-04-10 : 07:07:55
DTS is a client application so has to log in to the server with a logins mapped to both databases both databases. The error could come from either of the connections.

check the login you are supplying for the connections.

Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

- Advertisement -