Overview
Data flow transformation for extraction of information from input column containing XML document, using XPath expressions. The script has the following parameters:
- InputColumn – selects input column containing XML document to process.
- XPath – specifies XPath expression for extraction process.
- Namespaces – specifies the namespaces used in the XPath expression. The format is [namespace prefix]=[namespace]. Multiple namespaces are separated with newline.
- ResultSeparator – specifies elements separator.
Requirements
Depends on CozyRoc Script Component Plus component for implementing parameters user interface.
Library references
- System
- System.Data
- Microsoft.SqlServer.TxScript
- Microsoft.SqlServer.PipelineHost
- Microsoft.SqlServer.DTSPipelineWrap
- Microsoft.SqlServer.DTSRuntimeWrap
- Microsoft.SqlServer.ManagedDTS
- CozyRoc.SSISPlus
- System.XML