Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Wednesday, March 06, 2013 3:33 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 7:50 AM
Points: 27, Visits: 294
Hi,

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

Example:
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,
Unnati






Post #1427671
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse