Hi,

I am trying to copy a database using the Database Transfer Task in
SSIS. My package always fails with the following error 0x80131500 (
-1073548784 ) saying that the login XXX already exists in the database.



When I change my package to run between two SQL 2000 instances,
everything works.


Microsoft documentation says that it should work between 200 and 2005.


Any idea?


Thanks,

Hello larchevv,

Have a look through profiler at the code being generated by the task. If
that still fails then is using BACKUP and RESTORE an option?


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

I can always use BACKUP AND RESTORE. It is very annoying that Microsoft
always creates those "helpers" that always ends up causing more
problems that help.



Allan Mitchell wrote:

The main reason why I wanted to use the Transfer DB task is that it is
SUPPOSE to take care of the logins and users transfer as well.

larchevv wrote:

I'm having the same problem, although, instead of it being the login
that already exists it's a role for me. Have you figured out a way
around this? It really is frustrating because you don't have control
on the actual script that's being used to transfer the database.

Thanks in advance.


larchevv wrote:

In the Transfer Database task I can see no way for the task to take care of
logins. Users yes as they are in the DB being transferred.

--


Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com