The Read XML task can read data from

XML

files and load that data into a RowSet variable. That variable can then be used to import the data into a database or translated to another file type such as Excel, fixed-width, or

CSV

.

XML files by nature can contain multiple levels of elements and various data throughout them. Therefore you can add multiple RowSet elements to the Read XML Task by adding them through the

Add

button in the sub-menu. For example, you could have an XML file that contains customer information along with a list of the products they ordered. The customer information can be parsed into one RowSet and the list of products into another RowSet. Those variables can then be used to load two separate database tables.