SSIS 2008 Edit XML Column


  • HI,

    using SSIS 2008

    My data source has an XML column called : DataXml

    Also i have 2 other xml columns from other sources : XMLOne, XMLTwo

    I want place XMLOne & XMLTwo under one of the XML nodes of DataXML



    XMLOne =


    XMLTwo =


    DataXML =


    Want to DataXML column or create a new Column with :

    DataXML =


    What is best way for me to do this ?

    I thought of using script component but the dataset I'm working with has a lot of columns so if there's a way to to edit or create new column without need to recreate entire dataset in a script would prefer that

    Also, cannot use expression of substring and string manipulation to do this in a derived column since XML column is of type DT_NTEXT and those functions dont support that data type

    Sunday, May 19, 2013 10:45 PM

All replies

  • Are you talking about merging tow XML files into one? I am not sure, but SSIS does not offer a lot in terms of manipulating on XML.

    The best bet if you know XSLT is to try the XML Task -

    Arthur My Blog

    Tuesday, May 21, 2013 2:04 PM