Last post May 11, 2016 02:55 AM by Yohann Lu
May 10, 2016 05:15 AM|bokbob|LINK
Hi I would need to consume data from REST API using SSIS package so that later on we can set up a job using that package to import results/data on daily basis.
Please guide me on how to get started? I have never created SSIS package before and requirement is to create a package and deploy it.
May 11, 2016 02:55 AM|Yohann Lu|LINK
As far as I know, you can use the following options to make the Http request with the help of the Script Task in SSIS.
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: