Xml Ssis Data Flow Component?
There is a table with a column that contains Xml documents.For each record from my Data Flow Source, I want to pass in theXml document and thenode 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?
July 2nd, 2007 5:56pm

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. AScript 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.
Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2007 9:03pm

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/
April 14th, 2011 10:22am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics