How to connect Rest of API IN SSIS

_{Tuesday, April 11, 2017 5:04 AM}

I am using 2016 SSDT how to connect the API using HTPP connction in ssis .PLease help on this.

What is required for connecting API in SSIS .

I have URL and USER name And psw is there but not responding to the server.

_{Sunday, April 16, 2017 5:48 PM | 1 vote}

1) Third party tools such as CozyRoc or BlueSSIS. 2) Script Task with WebClient 3) Script Task with HTTP Connection Manager

The following links introduces how to start with REST API data in SSIS.

1: make an HTTP request from SSIS:

2: Microsoft SQL Server Integration Services:

3: Example using Web Services with SQL Server Integration Services:

Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

_{Thursday, March 14, 2019 11:14 PM}

Here it is a tutorial for REST API in SSIS:

MVP MCT MCTS Daniel Calbimonte

Additional resources