Please let me know when i copy a table from database A into Database B, does it copy the constraints also or data alone. If yes, then please let me know.
Creating constraints is not the default. I'm assuming you want DTS to create the table before importing. If you use the DTS Import/Export Wizard and choose "copy objects and data between SQL Server databases" you can specify that you want to create constraints.