Share via

Extract data from Rest API using SSIS Script task

thavha 0 Reputation points
2023-04-26T07:39:02.76+00:00

I am new on SSIS, and I don't have a good knowledge of C# Code.
Can you please help me on how to write the code in getting the data by calling a Rest API, I have the API and I am able to do all the transformation after getting the data. I am only stuck with extracting data due to my limited knowledge on C#

SQL Server Integration Services
SQL Server Migration Assistant
SQL Server Migration Assistant

A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.

Developer technologies | C#
Developer technologies | C#

An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.


2 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 27,106 Reputation points
    2023-04-26T19:38:15.98+00:00
    1 person found this answer helpful.
    0 comments No comments

  2. ZoeHui-MSFT 41,551 Reputation points
    2023-04-27T02:42:26.8433333+00:00

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.