

In order to start, we will show several examples.

It supports advanced filtering along with a flexible approach to configuring request parameters for web service.

SSIS XML Source can be used to consume multiple XML files or XML formatted response from SOAP Web service or REST API Web Service. This component is optimized to work with very large files. JSON component also supports JSONPath to filter data from nested array/sub-documents. JSON Source Connector can be used to extract and output JSON data stored in local JSON files, JSON data coming from REST API web service calls (Web URL) or direct JSON String (variables or DB columns).
