SSIS Package to read data from JSON file

Question

Hi Team,

I have a requirement where I need to read the JSON file which is getting created at shared location in every few second, and load the JSON data in database.

I wanted to understand if I can create a SSIS package which can be schedule to execute every minute to extract the JSON file data and load into database.

Thanks,
Isteyak Ahmad

Answer 1

Starting with SQL Server 2016, you can read JSON directly from T-SQL using the OPENJSON function. For further information, check the post here.

Answer 2

There are several third-party tools to connect to JSON files like ZappySys, and Cozyroc.
You only need to download the software and connect to your json file with those third-party components.

To schedule, you can use the SQL Agent to run the jobs.

Answer 3

Hi @isteyak ahmad ,

We may use script component to meet the requirement in SSIS.

Step by step you may refer below.

importing-json-files-using-sql-server-integration-services

If you want schedule the package, you may scheduling Jobs in SQL Server Agent.

sql-server-agent-jobs-for-packages

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October