how the orchestration should parse the xml & query the appropriate table based on Id attribute.

HI Guys,

Please can any one help the below task.

Task:

–We have some info, once the info saved it’ll store the sql table particular column.

–The column info should be as an xml,we need to retrieve the xml info and store it particular xmldocument varible using xpath.

 — how to read the xml value (Sample XML) and our orchestration should
parse the xml & query the appropriate table based on the ID attribute
value and map the SQL response to the appropriate filed in Output xml.

please can any one help asap….

Thanks in advance…

Regards,

Raja…