sql server dts: I'm trying to transfer a Database to Production database, by using DTS

I get the following error

There is already an Object named "PK_Users" in the database
Could not create constraint. see previous message.

What I have to do to get rid of this error, any help would be appreciated.

Thanks

It means what it says. There is already an object called PK_Users in the
DB. Are you using the transfer objects task ? Did you choose to drop
existing objects?

IMHO if you want to move a DB complete from Server to server use BACKUP /
RESTORE

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community