...
i.e., The rows in PTG_ImportStaging_tblParty.PrimaryPartyType have a properly configured and matching value in the corresponding PrimaryPartyType Lookup Group. The assigned engineers can then easily check the exceptions and work through the reported exceptions with ease.
Inserting to destination tables
Once the data is ready to be loaded, we can make the use of a MERGE INTO to be able to insert rows as we copy back the generated ID’s to the staging tables through an OUTPUT clause.
...