Something like this..
CREATE TABLE SSNTemp (
SSN char (10) NOT NULL
)
CREATE UNIQUE
INDEX [IX_SSNTemp] ON SSNTemp ([SSN])
WITH
IGNORE_DUP_KEY
insert into SSNTemp
select ssn from yourssntable
delete from yourssntable
insert into yourssntable
select ssn from SSNTemp
_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring