SSIS XML Source - Read from XML Files, SOAP Web Service or Consume REST API

  • 8 years ago
Learn how to read XML data in SSIS. Parse XML and load into database (e.g. SQL Server). Read from XML files, SOAP Web Service or REST API. Learn more http://zappysys.com/products/ssis-powerpack/ssis-xml-source/

=============================
Description:
=============================
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.

=============================
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
◾Support for looping through multiple files using wildcard pattern (e.g. *.xml).
◾REST API Paging support to loop through multiple requests (see)
◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)