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 |
|
tibetandog
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 |
|
|
nr
SQLTeam MVY
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. |
 |
|
|
|
|
|
Urgent: can't copy data between two databases/ DTS