I have a table which has a column of type XML.
My ETL logic requires me to run XPATH expressions on each row of data and then upload the results into DB.
I looked at the XMLTask in the Control flow, but it only applies to one document and not to row-by-row.
In the DataFlow there is no XMLTask which allows to apply XPath expressions on each row of data.
Now should I resort to the "script" task?? or is there any elegant way to handle the XML column.
View Complete Post