Another approach:

INSERT INTO maintable(pk_field, field1, field2, etc...)

SELECT s.pk_field, s.field1, s.field2, etc...

FROM stagingtable s

WHERE s.pk_field not in(SELECT pk_field FROM maintable m)