If you do not want to parse hierarchical elements, you can pack the elements into one field. You can also pack array elements when you write to the target.
A pack icon appears next to elements on the
tab. When you select the pack icon that appears next to the element, the agent packs the element and its child elements into a single XML string during runtime. You cannot select fields that are child elements of packed fields in field mapping.
You can unpack fields by clicking on the pack icon.
To pack the fields, click on the pack icon that appears next to the rows element.
The following image shows the packed rows element:
The following sample shows the output of the Rows field in the target file after you run the task: