How to parse XML file with multiple namespaces

 

Steps to parse XML files with multiple namespaces in SSIS

1. Get rid of multiple namespaces

follow the thread below, bascially apply XSLT to regenerate an XML

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/2fde216c-01ab-42a5-8b43-52f5f42d35bc/multiple-namespaces-in-an-xml-document

2. Once cleaned XML has been created, follow the thread below to parse only required information using XSLT

http://blog.hoegaerden.be/2011/04/20/loading-complex-xml-using-ssis/

3. The output is the CSV file which can be inserted into tables easily