SSIS Web API Integration Pack (Call REST API, SOAP Web Service)
SSIS Web API Integration Pack is your complete toolset to automate REST API/Web API/SOAP/OAuth/OData Service integration in SSIS. Using simple drag and drop interface you can consume data from any Web Service in few clicks (XML or JSON format). You can also send Ad-hoc request to any web server including file upload requests. It includes JSON Source Connector, XML Source Connector and REST API Task.
SSIS JSON Source (File, REST API, OData Connector)
SSIS XML Source (SOAP Web Service, XML File Connector)
|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.|
SSIS REST API Web Service Task
|SSIS REST API Web Service Task can be used to automate any HTTP Web Requests (e.g. GET, POST, PUT, DELETE). You can pass credentials using Basic Authorization or OAuth 2.0. You can save response extracted using this task to SSIS variable or file.|