You can extract employee names and addresses from an XML file and create a Microsoft Excel sheet with the list of names.
The mapping has the following components:
XML source file. Contains employee names and addresses.
Source Qualifier transformation. Passes XML data and an output file name to the Unstructured Data transformation. The XML file contains employee names.
Unstructured Data transformation. The input type is buffer and the output type is file. The Unstructured Data transformation receives the XML data in the InputBuffer port and the file name in the OutputFileName port. It passes the XML data and the file name to
Engine runs a serializer service to transform the XML data to a Microsoft Excel file. It writes the Excel file with a file name based on the value of OutputFilename.
The Unstructured Data transformation receives only the output file name from
Engine. The Unstructured Data transformation OutputBuffer port returns the value of OutputFilename.