My process involves getting a large XML file on a daily basis. I have developed an SSIS package (2008 r2) which first gets rid of the multiple namespaces via a XSLT and then imports data into 40 tables (due to its complexity) by using the XML source object.My process involves getting a large XML file on