using biztalk Adapter for SQL Server is it possible to update or insert a record in database based on condition
suppose i have flag in xml incoming document o or 1
based on the flag i want to update the two different tables
how can i do this , is it possible do to while mapping the documents or i have to some thing else.

help me very urgent.

thanks in advance


syedjavid

__________________
syedjavid

Hello,

It is possible with XLANG orchestration.
Receive the document, make a decision with a specific field, start/or not a channel for update the db.

On my side I get an error with the aicsql_sample provided in the Learnbiztalk :
My channel accept only an INSERT statement with 'block' and 'after' or a stored procedure with 'sproc'. and only one operation for a single file.

the delete/update statement with 'block' & 'before'
or sproc and block in the same file doesn't work and generate an error 0x80004005 unable to analyse the document

Any idea?

Eric.