Contents hide 1 Introduction 2 Prerequisites 3 REST API Concepts 4 Video Tutorial 5 Configure SSIS JSON Source to Read from REST API or local File 5.1 Configure Connection – Pass credentials 5.1.1 Configure HTTP Connection 5.1.2 Configure OAuth Connection 5.2 Example of JSON/REST API Source 6 Loading data from REST API to SQL Server … Continue reading How to load JSON / REST API to SQL Server in SSIS