Unable to separate XML data to sql server column

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Unable to separate XML data to sql server...

Unable to separate XML data to sql server column

Rate Topic

Display Mode

Topic Options

Author

Message

unnati.patel513

Posted Wednesday, March 06, 2013 3:33 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 10, 2013 12:47 PM
Points: 19, Visits: 230

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 »

Permissions