Thanks Matt! I actually do need to perform this type of query also.

SELECT *

FROM TableWithNewData

WHERE (Column1 NOT IN SELECT Column1 FROM TableWithOldData AS old_Column1)) AND

(Column2...

Never mind! I figured it out.

Can I do this: after I've put the data into the temp table, can I do a dts task to execute sql script that will run the update and put...