Jeff Moden (9/10/2012)
the first place to start would simply be to join the new table with the existing table based on the first name, last name, and DOB and use that join to update the new table.
I agree, assuming the SSN data is on the same instance where the flat-file is headed.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato