-- XMl source component gives error saying xml contain multiple namespace ,when "Generate XSD" button is pressed. Please advice how to load xml file with multiple namespace to a SQL Server table.

I think you can import this XML file using a Script Task in which you would need to use the .Net built in XML handling routines. For example XQuery if you follow this post: http://beyondrelational.com/blogs/jacob/archive/2008/10/11/xquery-lab-37-working-with-multiple-namespaces.aspx or you may load it into SQL Server as is (perhaps) and handle it by the means of T-SQL. As a side note: I recall dealing with such a case and if I remember right I coped with it by just dropping one of the namespaces (because it was not used) and then I was able to load the modified file (I altered it using a Script Task).Arthur My Blog

you can also use XML Task with XSLT to simplify your complex xml first, and then use the new xml data in xml source.http://www.rad.pasfu.com