In short: you can use INSERT with OUTPUT clause.

But, if you could specify which table you are going to load your data from, that would allow to advice you in more detailed way.

We will need your tables DDL. The link at the bottom of my signature leads to article explaining how to post one.