Overview
XML Source Component is an SSIS Data Flow Component for retrieving data from an XML document. It supports multiple outputs via the composite records pattern.
- Supports reading XML files.
- Supports composite outputs in a more efficient manner than the standard XML Source.
- Supports the following XML sources: File and Variable.
- Component metadata is initialized from an XML Schema Definition (XSD) or inferred from a provided XML document.
- Supports an error output for redirecting problematic records (in case of a failure processing the field values).
Quick Start
In this section we will show you how to set up an XML Source component.
- When clicking on Columns tab the component would prepare the outputs and external columns by analyzing the existing schema information. Please note that the XML Source can have multiple outputs (see the article about composite records), which columns you can see. The data in these outputs can be processed by downstream transformation and destination components(e.g. multiple OLE DB Destinations can store the data in SQL Server database).
- Click OK to close the component editor.
Congratulations! You have successfully configured the XML Source component.
Parameters
Configuration
Use the parameters below to configure the component.
Indicates the source of XML data. The following options are available:
Value Description File Select an existing File Connection Manager or create a new one. Variable The XML data is available in a variable. Select a variable or create a new one.
Knowledge Base
What's New
2.3
- New: Introduced component.
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.