none
SSIS 2008 Edit XML Column

    Question

  • 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

    Ex:

    Current

    XMLOne =

         <ignition>10</ignition>

    XMLTwo =

        <speed>100</speed>

    DataXML =

        <root><data/><root>

    Want to DataXML column or create a new Column with :

    DataXML =

        <root>
              <data>
                    <ignition>10</ignition>
                    <speed>100</speed>
              </data>
          </root>

    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 - http://brainmeta.com/forum/index.php?showtopic=9800


    Arthur My Blog

    Tuesday, May 21, 2013 2:04 PM