SSIS XML Integration Pack

SSIS XML Integration Pack (Files, SOAP, REST)

SSIS XML Integration Pack is your complete toolset to automate XML integration scenarios in SSIS (e.g. Consume/Produce/Parse). Using simple drag and drop interface you can read data from XML files or XML Web Services (i.e. REST API/SOAP). It includes XML Source Connector, Export XML File Task, XML Parser Transform and XML Generator Transform.

Features

  • Read XML data from any SOAP/REST API Web Service using methods such as GET/POST.
  • Read XML data from single or multiple XML files (use of wildcard allowed. e.g. c:\data\*.xml)
  • Support for Path expression to extract data from any level (e.g. Extract Orders nested under Customer Node).
  • Support for passing custom headers to SOAP or REST Web service
  • REST API Paging support to loop through multiple requests (see)
  • Parse source XML String/Documents into multiple columns/rows.
  • Ability to de-normalize nested XML data into flat structure
  • Create simple or nested XML documents inside DataFlow Task using simple drag and drop approach
  • Ability to create nested XML from Multiple datasets
  • Ability to create single XML document for all input records or create one document for each input row from ROOT dataset
  • Export multiple tables/views to XML files (e.g. Sales% or do SalesJan|SalesFeb)
  • Export SQL query output to XML file
  • Inbuilt Layout Editor for creating complex XML with nested structure (Document Array, Value Array, Nested attributes
  • Automatically Split exported XML data into multiple files by Size or Number of records
  • Automatically Split exported XML data into multiple files by Split By Column (e.g. SplitBy=Country will create new file for each country)
  • Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
  • Articles/Tutorials: XML related articles
Download Buy View All Tasks

SSIS XML Source Connector (XML File, SOAP Web Service)

SSIS XML Source SSIS XML Source can be used to consume multiple XML files or XML formatted response from SOAP Web service or REST API Web Service. It supports advanced filtering along with flexible approach to configure request parameters for web service. 

Read more

SSIS XML Generator Transform

SSIS XML Generator Transform SSIS XML Generator Transform can be used to generate single or multiple XML documents from any type of datasources (e.g. SQL Server, MySQL, Flat File, Excel) inside dataflow task. 

Read more

SSIS XML Parser Transform

SSIS XML Parser Transform SSIS XML Parser Transform can parse XML string into multiple columns and rows (Helpful to extract data from raw XML string stored as database column or coming from other source). 

Read more

SSIS Export XML File Task

SSIS Export XML File Task SSIS Export XML File Task can be used to generate simple or complex XML files out of relational data source such as SQL Server, Oracle, MySQL. In few clicks you can create desired XML Shape from single or multiple tables (Parent/Child Nested Documents). 

Read more

 

Download View All Tasks