Hello,
Here I would like to share a SSIS REST API to SQL ,In this blog post you will learn how to load data from JSON file or REST API to SQL Server (or other RDBMS systems e.g. Oracle, MySQL) in just a few clicks. We will use SSIS JSON / REST API Source Connector to pull data from REST API and load into SQL Server. Along with REST API, you can use JSON Source to read files and direct JSON String.
Feel Free to See…