SSIS XML Source (Read from File, SOAP Web Service or REST API Web Service)

SSIS XML Source (File, SOAP, REST API)

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)
  • Articles/Tutorials: XML related articles

Download Help File Buy
View All Tasks
ScreenshotsUseful LinksSystem Requirements

Direct URL – Read from XML Web service URL – Call XML REST API Service and get de-normalized resultset

SSIS XML Source - Direct Mode - Call REST API web service or read from XML File

Direct File Path – Read data from XML files (Single or Multiple files) – Use wildcard pattern in path

SSIS XML Source - Read data from XML files (Single or Multiple files) - Use wildcard pattern in path SSIS XML Source - Read data from XML files (Single or Multiple files) - Use wildcard pattern in path

Direct Value – Read from XML String

Read XML data in SSIS

File Path or URL from Variable – Read XML String stored in SSIS variable

SSIS XML Source - Variable Mode - Call Web API or Read from File

Select columns, edit datatype

SSIS XML Source - Configure Columns and DataType

  • .net framework 3.5 or higher must be installed
  • SSIS Runtime: To execute SSIS package you will need one or more versions of SQL Server Integration Services 2005/2008/2008 R2/2012/2014 or 2016
  • To design SSIS 2012 package SSDT (VS 2010 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2014 package SSDT-BI (VS 2013 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2016 package SSDT-BI (VS 2015 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2005, 2008, 2008 R2 packages BIDS (VS 2005,2008 Shell – Business Intelligence Development Studio) must be installed.
  • Supported Client Operating Systems: Windows 7, Windows 8, Windows 8.1
  • Supported Server Operating Systems: Windows Server 2003/R2, Windows Server 2008/R2, Windows Server 2012/R2
Download View All Tasks Like This