InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 06:42:15 GMT20http://www.sqlservercentral.com/Forums/Topic1427671-364-1.aspxHi,I am trying to split XML attributes and load to the Sql server table.I have uploaded script for create the table as well as insert the script with has XML attributes.I want to split XML Column name called transXml in the table and put it into destination table(i have upload destination table script)I have creates destination table based on XSD name call STG_Ins_UW_PolicyAdmin_Work_Application.Need to map base on Column nameExample:Like in XML there is one attributes is TermNumber which is there in destination table(.For More information i have uploded XSD which i need to use for this task.I have created destination table based on XSD structure.Please help me. i am new in XML and SSIS.Give me best solution how i can achived this through SSIS.Thanks in advanced.Thanks,UnnatiWed, 06 Mar 2013 15:33:15 GMTunnati.patel513