Using the SQL Transport Schema Generation Wizard in BizTalk Server only
one table can be selected within a datagram. The schema generated would have
only one table in the datagram. We are trying to modify the schema in such a
way so as to insert multiple rows in a master and detail fashion.
The master table would generate a key value for every row inserted and
the detail row/rows would use the same key generated by the master table to
insert rows in the detail table.
NOTE: Any promoted property which would be the same across
all the messages can also be used as the correlation type property.