You do not need to extract data into a holding area first - just do it all in one statement, eg (untested):

INSERT into [dbname].[schema].target(Field1, Field2, ... Fieldn)

SELECT Field1, Field2, ... Fieldn from [dbname].[schema].source Source

WHERE Source.PK not in (SELECT PK from [dbname].[schema].target)