Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KnooKie
Aged Yak Warrior
623 Posts |
 Posted - 2001-05-21 : 09:22:35
|
| I have an external data feed that has duplicate records in it. I have a DTS script that handles moving the data from it's source to SQL Server 2000 tables with no keys/indexing/constraints on them.I then want to move the data to tables with primary keys/indexes/constraints on them. During this 2nd phase i need to remove/ignore any duplicate records either on the source before copying the data over or during the copy process of the DTS.I'm inclined to think some sort of stored procedure prior to the copy would be best. Any advice on doing this or approaching it a different way would be most helpful.thanks |
|
|
|
|
|
Deleting DTS duplicates