Contents hide 1 Introduction 2 What is REST API / RESTful Web Service 3 Tasks/Components in SSIS for Consuming RESTful API / WebService 4 Using SSIS JSON Source to read from REST API and load into SQL Server 5 REST API Task – Ad-hoc web requests – Call REST API (POST, DELETE) 6 HTTP GET … Continue reading How to Call REST API in SSIS – Read JSON / XML / CSV