I'm trying to read in a block of XML data from a data base table in VB.ÃÂ I'd like to read in theÃÂ chunk of XML in the script componet and use XPath to breakup and send out seperate columns.ÃÂ I'm stuck on how to read in the block from the input buffer.ÃÂ I though I could do this:
Public Overrides Sub input0_ProcessInputRow (ByVal Row As input0Buffer)
ÃÂ ÃÂ ÃÂ ÃÂ Dim docNav As XPathDocument = New XPathDocument(Row.XMLChunk))ÃÂ //where this would bring in the XML and create a XPath document object
where XML Chunk is the Input Column name.ÃÂ I know this should be easy to do I just have never had to work with XPath and crazy XML formatted messages.
View Complete Post