title: SSIS reading multiple xml files from folder
body: <p>Hi all i'm new to SSIS and i'm wanting to read a bunch of xml files in a specific folder. I would like to read the xml files and output the data in a database table. However i'm a little bit confused as to where to start. Could someone point me in the right direction? I've had a search on the internet but all the tutorials seem to cover looping through txt files and not xml files. I will be using sql server 2005 if that makes any difference.</p>
  
  <p>Many thanks :)</p>