Here is Simple XML example

Simple XML Example

To load it all we need to do, is to set 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 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

Download Free Trial Learn More About Our ETL Software

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies