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.
Many thanks :)