BizTalk Server Applications Integration - Using updategrams with SQL Adapter

Author

Using updategrams with SQL Adapter

Farrukh Hassan

2004-11-02, 7:46 am

I am trying to use SQLAdapter updategram to insert/update
multiple records at the same time. An option is vailable
in updategrams to have multiple records updated within a
single sync (before/after) tag, i.e. to use a
distinguishing attribute updg:id (where updg pointing to
urn:schemas-microsoft-com:xml-updategram). How can I
specify the updategram schema to generate xml with updg:id
with each records.

I tried <xs:attribute updategram:Prefix="updg" name="id"
type="xs:string" />, but the resultant xml doesnt
do "updg.id" rather simply "id". Thus not fullfilling the
purpose.