Re: Consume adapter service Insert-operation and identity value

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Consume adapter service Insert-operation and identity value › Re: Consume adapter service Insert-operation and identity value

August 19, 2009 at 6:31 AM #23065
community-content

    One possibility is to use a stored procedure:

    mystoredprc @T1Field1, @T1 Field2, @T2Field1, @T2field2
    BEGIN
      INSERT INTO Table1 (FieldName1, FieldName2) VALUES (@T1Field1, @T1 Field2)
      INSERT INTO Table2 (Table1ID, FieldName1, FieldName2) VALUES (@@IDENTITY, @T2Field1, @T2field2)
    END

    Use a composite request as described by Richard in his blog to group multiple stored proc calls.