COZYROC XML components, part of COZYROC SSIS+ suite, are third-party plug-ins for Microsoft SSIS that make it easy to parse and generate XML files. The toolkit is easy to use and follows the same guidelines and principles used by the standard out-of-the-box SSIS components.
The XML integration package consists of:
- XML Source component
- Reads and parses XML from a variable, file or direct text.
- XML Destination component
- Generates XML data.
XML Source
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.
XML Destination
In this section we will show you how to set up a XML Destination component.
- In the SSIS Toolbox, locate the COZYROC's XML Destination 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 conection where generated XML data will be stored.
- Provide XML Schema Definition (XSD), sample XML or XML Destination Model file.
- External columns are automatically generated for all bindable elements. Their DataType, Lenght, Scale, Precison properties can be configured additionally.
In case the desired XML file contains elements with values for which data is not expected to come from upstream components, the source type can be changed to Variable or Constant.
- On the advanced settings page, if necessary, change values for File Encoding, DataTime output format, Ident output, Output NULL values as xsi:nil and Do not output XML declaration.
- When clicking on Mapping tab the component would prepare the inputs and external columns by analyzing the provided (or inferred from sample file) XML Schema Definition. Please note that the XML Destination can have multiple inputs (see the article about composite records), which columns you can see. The data in these inputs is usually provided by upstream source or transformation components that support composite outputs (e.g. a Query Transformation can be used to retrieve the necessary data from SQL Server database).
- Click OK to close the component editor. Congratulations! You have successfully configured the XML Destination component.
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. 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
Overview
XML Destination Component is SSIS Data Flow Component for generating an XML document and saving it to a file. The component can process unlimited amount of data with capped memory use.
- Component metadata is initialized from a provided sample XML document or from a sample XSD file.
- Depending on the type of XML element, it can be populated from an input column, variable or a fixed value. Array elements are represented with separate inputs (see the composite records pattern).
Demonstration
Quick Start
In this section we will show you how to set up a XML Destination component.
- In the SSIS Toolbox, locate the COZYROC's XML Destination 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 conection where generated XML data will be stored.
- Provide XML Schema Definition (XSD), sample XML or XML Destination Model file.
- External columns are automatically generated for all bindable elements. Their DataType, Lenght, Scale, Precison properties can be configured additionally.
In case the desired XML file contains elements with values for which data is not expected to come from upstream components, the source type can be changed to Variable or Constant.
- On the advanced settings page, if necessary, change values for File Encoding, DataTime output format, Ident output, Output NULL values as xsi:nil and Do not output XML declaration.
- When clicking on Mapping tab the component would prepare the inputs and external columns by analyzing the provided (or inferred from sample file) XML Schema Definition. Please note that the XML Destination can have multiple inputs (see the article about composite records), which columns you can see. The data in these inputs is usually provided by upstream source or transformation components that support composite outputs (e.g. a Query Transformation can be used to retrieve the necessary data from SQL Server database).
- Click OK to close the component editor. Congratulations! You have successfully configured the XML Destination component.
Parameters
What's New
2.1 SR-1
- New: Support for external XSD references when initializing the document model.
- New: Improved support for namespaces, self-referencing elements, attribute group references and simple type restrictions.
- Fixed: Attributes namespaces.
- Fixed: Incorrect default scale for decimal fields.
- New: Support for data streaming.
2.1
- New: Introduced component.
Related documentation
XML Destination
2.1 SR-1
- New: Support for external XSD references when initializing the document model.
- New: Improved support for namespaces, self-referencing elements, attribute group references and simple type restrictions.
- Fixed: Attributes namespaces.
- Fixed: Incorrect default scale for decimal fields.
- New: Support for data streaming.
2.1
- New: Introduced component.
Knowledge Base
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.