Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Unable to separate XML data to sql server column Expand / Collapse
Posted Wednesday, March 6, 2013 3:33 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 2:18 PM
Points: 27, Visits: 304

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.


Post #1427671
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse