locked
Xml Ssis Data Flow Component? RRS feed

  • Question

  • There is a table with a column that contains Xml documents. For each record from my Data Flow Source, I want to pass in the Xml document and the node to interrogate, and return the value contained in the node.  Like the Crm component, this is probably one I will have to write from scratch in C#, but I would like to avoid having to create the custom component if it already exists in the public arena. 

     

    Does anyone know of any Xml Ssis Data Flow Components that are downloadable for free?

    Monday, July 2, 2007 2:56 PM

Answers

  • There is no XPath / XQuery transform in the public arena. There's a stock xml task, an stock xml enumerator, and am xml Source pipeline, but no XPath transform.

     

    A Script Component Transform (synchronous to the input) could be built to accomplish evalution of an XpathExpression against an xml column, placing successful matches in an output column.

     

    Monday, July 2, 2007 6:03 PM

All replies

  • There is no XPath / XQuery transform in the public arena. There's a stock xml task, an stock xml enumerator, and am xml Source pipeline, but no XPath transform.

     

    A Script Component Transform (synchronous to the input) could be built to accomplish evalution of an XpathExpression against an xml column, placing successful matches in an output column.

     

    Monday, July 2, 2007 6:03 PM
  • Check this script for reference how to extract information using XPath in the SSIS data flow.
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
    Thursday, April 14, 2011 2:19 PM
  • Hello, you may need to use third party components to read XML data:

    https://zappysys.com/products/ssis-powerpack/#cat_file_xml

    The other option would be a script task, but yes I would try to avoid that option as well.


    MVP MCT MCTS Daniel Calbimonte

    http://elpaladintecnologico.blogspot.com

    Friday, July 31, 2020 11:47 AM