Is there a way to pull data from XML columns with SSIS? I mean parsing the XML and pulling only data from XML column without putting it into an XML file first. I have been using xpath queries (XML value method) to do this. Is there any other way? Thanks

Is there a way to pull data from XML columns with SSIS? I mean parsing the XML and pulling only data from XML column without putting it into an XML file first. I have been using xpath queries (XML value method) to do this. Is there any other way? Thanks You can implement script component in the data flow which does extraction with XPath. Check this script for reference.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

XPath is good way, combination the XML task with XPath led result as you need. Let us know what is your problem with XPath?http://www.rad.pasfu.com