Hi
I think bellow query can help you:
-----------------------------------------------------------------------------------
Insert [DestinationTable](FirstColumn, ...)
Select [SourceTable].[FirstColumn], ...
From [SourceTable]
Where Not Exists
(Select *
From [DestinationTable]
Where [IdentityColumn] = [SourceTable].[IdentityColumn]
)
-----------------------------------------------------------------------------------
I hope it's helpful.