> larchevv 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 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:
>> > > 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
>> > >
>> > > > 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,
>> > > >
>