Here is a simple XML example

Simple XML Example

To load it all we need to do, is to set the data source type to XML and select appropriate XML tags for "Table Tag" and "Record Tag"

Data reader settings :
Simple XML Data Reader Settings

Note: "Ignore Tags" is checked

Here is our data in the grid:
Simple XML Data

More complex XML example:

XML With Additional Tags

Note that we have here an additional tag <TableName>. To load this data we need to uncheck "Ignore Tags"

Here is our data in the grid:

XML With Additional Tags Data

Related articles

  1. Advantages and disadvantages of working with XML
  2. Generating XML 
  3. XSLT Transformation
  4. ETL and XSLT
  5. Using XSLT for ETL transformations
  6. Advanced ETL Processor performs XSLT transformations


Direct link, no registration required.