may be you have duplicate records into new one:

try that:

INSERT INTO ListManager.dbo.members_ (EmailAddr_, Additional_,

Domain_, UserNameLC_, List_, DateJoined_, FullName_)

SELECT distinct EmailAddr_, Additional_,Domain_, UserNameLC_, List_, DateJoined_, FullName_

FROM #TEMP t

--for excluding duplicates...