Open topic with navigation
In this dialog box, the XML Component creates a table definition based on the root node of the source document and creates a field collection that derives from the schema.
The XML Component primarily supports Insert on the target side. However, depending on the target settings, the Component may perform an Update to the document.
Take, for example, a job that reads a transaction file of customer information and creates an XML document containing a list of customers with their most current address. You need to sort the input by customer and transaction date/time, and the target settings need to indicate that customers repeat. As long as the customer is the same, each address updates the existing address with new information. However, if the customers are out of order, this type of processing doesn't occur.
Connecting to XML
Creating an XML Target Connection
Target Side Component Settings