Adding XML Data Sink to a project opens a Component window and a properties section. Use the objects to define the structure, content, and location of the XML output.
To add an XML Data Sink Component to a project
Add the component.
Enter a file name for the destination file by using the Property Window or selecting Destination from the Properties menu.
You can change the content and the shape of the XML Document by either dragging Input Port Attributes to the XML Output Definition or by right-clicking on any item listed in the XML Output Definition.
Exit the component window with the Save button.
The XML Write component writes the XML output in the
order it receives from the incoming data stream. If you want to
ensure that your hierarchies are represented correctly, you need
make sure that the attributes used for grouping your hierarchies
are delivered in the right order.
If the originating data stream does not deliver the data stream in the right order, you should consider using a DB Staging Component before outputting the data to the XML document. The SQL Statement delivering the data FROM the DB Staging Component should have an ORDER BY clause containing all attributes you use for grouping in your XML component in the right order.
