Unable to separate XML data to sql server column

  • 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

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply