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 name
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.