DTS job to copy

I created a DTS package to copy a database from one server to another. I want to change the collation of the existing database to insenseitive. During the set up of the DTS package I didn't check off collation , so I assume my destination database will override the source. I had an error after and and the process finished
[microsoft][odbc sql serverdriver][sql server]user or role "user_name"already exists in the current database
what happened, and how can I correct it.I would guess you either already had a user in the database or you have
two users in the source database which only differ in case and are
considered the same user in the destination.
Either don't copy users or get rid of the duplicates
try in the source
select upper(name)
from sysusers
group by upper(name)
having count(*) > 1
Nigel Rivett
www.nigelrivett.net
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!