You can map data from a response by writing an XPath expression that selects nodes from the rows returned. The XPath expression is used in a copy operation in an assign activity or directly in the Output data tab of the data access invoke activity.
For example, suppose the request message contains a statement such as:
SELECT EngineId, Name, State FROM AeEngine ORDER BY 1
You can extract a value, such as the State value in the first row of the
table with the following XPath expression: