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.
- In the SSIS Toolbox, locate the COZYROC's XML Source component and drag it onto the Data Flow canvas.
- Double-click on the component on the canvas.
- Once the component editor opens, select the fIle connection from File Connection menu. You will be prompted whether to initialize the XML document model from an XSD Schema file or to infer the model from the XML document. Make your choice.
- The XML schema will be loaded in the XML Source Editor. In order to receive some more information for the elements you can select an element in the tree and see the provided information.
- 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. Two types of connection manager are supported. FILE - for a single file. MULTIFILE - for multiple files; wildcards are also supported. Variable The XML data is available in a variable. Select an existing variable or create a new one.
The variable can be a string containing a filename or a filename with wildcards; an object containing one or more XML data streams.A variable that contains XML data.
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.