Thanks Greg!! This seems like the best approach I have tried and researched thus far. I get the stored procedure part about passing the records as XML and then shredding for the inserts. I should be able to use Scope_Identity or @@Identity to solve my foreign key issues which is great.
I’m a little confused on how to assign the stored procedure parameter from BizTalk. Right now, I have a map that represents the canonical schema I want to insert. What field is Leonid making distinguished and I’m assuming that is the field that is passed as the stored procedure parameter?
Thanks again….