locked
Derived Column Transform RRS feed

  • Question

  • Using Visual Studio 2008, I am trying to pull "MemberID" from the root node of an xml file(sample below) and put it into a table.  I'm using an "XML Task" to put it into a variable.  The variable will then be used by the Derived Column to put MemberID in table(Later, I need all this to be in a ForEachLoop to enumerate through several hundred files. For now, I just want to get the Derived Column working.)  I've attached pics of my "Data Flow" and the resulting table. The problem is that I get "MS.Internal.Xml.XPath.XPathSelectionIterator"  as the value of my derived column instead of getting the "MemberID" value as shown below.

    A sample of my XML is:

    <?xml version="1.0" encoding="UTF-8"?>
    -<MemberPoints>

      <MemberID>10005684</MemberID>

      <GroupID>1029</GroupID>

        -<Points>

          -<Point>

            <PointID>1000</PointID>

            <PointTrackerNumber>1058381</PointTrackerNumber>

            <PointName>Risk Assessment Completion</PointName>

            <ActivityDate>2012-12-06T15:05:30</ActivityDate>

          </Point>-

       </Points>

    </MemberPoints>

    Any suggestions on how to correct this?


    Jeff Bandy

    • Moved by Amanda Zhu Monday, October 7, 2013 5:57 AM Not VS General issue
    Thursday, October 3, 2013 9:52 PM

Answers

All replies

  • Hello,

    Thank you for your post.

    I am afraid that the issue is out of support range of VS General Question forum which mainly discusses WPF & SL designer, Visual Studio Guidance Automation Toolkit, Developer Documentation and Help System and Visual Studio Editor.

    I am moving your question to the moderator forum ("Where is the forum for..?"). The owner of the forum will direct you to a right forum.

    Best regards,


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey. Click &lt;a href=&quot;http://support.microsoft.com/common/survey.aspx?showpage=1&amp;scid=sw%3Ben%3B3559&amp;theme=tech&quot;&gt; HERE&lt;/a&gt; to participate the survey.

    Monday, October 7, 2013 5:56 AM
  • I figured this out.  The XPathOperation box in XML Task Editor must be set to "Values."

    Thanks


    Jeff Bandy

    Monday, October 7, 2013 2:50 PM
  • Might want to ask them over here.

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlintegrationservices

     

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    • Proposed as answer by Just Karl Friday, October 11, 2013 7:45 PM
    • Marked as answer by Just Karl Friday, October 18, 2013 2:32 PM
    Tuesday, October 8, 2013 1:13 AM