Remove From My Forums

consuming REST API data in SSIS

Question
0

Sign in to vote

User109943568 posted

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.

Anjana

Tuesday, May 10, 2016 5:15 AM

Answers

0

Sign in to vote
User36583972 posted

Hi bokbob,

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:

http://stackoverflow.com/questions/6684317/how-to-make-an-http-request-from-ssis

2: Microsoft SQL Server Integration Services:

http://microsoft-ssis.blogspot.sg/2011/05/download-source-file-from-website-with.html

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

https://www.mssqltips.com/sqlservertip/3272/example-using-web-services-with-sql-server-integration-services/

Best Regards,

Yohann Lu
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Wednesday, May 11, 2016 2:55 AM