Jan 25, 2017 · In this article, 1st of 2-part series, we will look at 2 approaches to import JSON in SSIS using 2 methods: the new functionality of SQL Server 2016 and the Json.NET library.

Mar 23, 2018 · SQL Server Integration Services does not support JSON natively, so we need to develop a custom source for a data flow task to load JSON file. In this tip, I will walkthrough a method to develop a bespoke source to load JSON files using .Net libraries.

Jan 17, 2020 · In this article, we explored importing JSON file into SQL Server tables using OPENROWSET and OPENJSON function. We also used an SSIS package for JSON data import. You should practice this as per your data requirements.

Mar 21, 2023 · How to load data from any REST API to SQL Server in few clicks. This article uses drag and drop SSIS JSON Source connector to call REST API (HTTP or OAuth)

May 19, 2018 · Parsing JSON Data Sources Using SSIS. This technique was written for SQL Server 2012. It uses a flat file source with single column with data type of text stream (DT_TEXT), then uses a Script Component as a transformation. In the Script Component, the key is to use the JavaScript Deserialize method from System.Web.Extensions.

Jul 2, 2021 · If you have need to integrate REST API in SSIS (i.e. fetch JSON, XML, CSV via HTTP call) and wondering how to Read API data in SSIS and Load into SQL DB (i.e. SQL Server, MySQL, Oracle) then you are at the right place.

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

Apr 9, 2025 · SQL Server Integration Services (SSIS) provides a powerful way to import JSON files into SQL Server for structured storage and analysis. This article explains how to configure an SSIS package using the JSON Source and Upsert Destination, both available in the ZappySys SSIS PowerPack.

Nov 8, 2023 · In SQL Server Integration Services (SSIS), you can load data from a JSON file using the JSON Source component. Here are the steps to load a JSON file in SSIS: Json file example (dummy data generated by AI) Open SQL Server Data Tools (SSDT) or SQL Server Management Studio (SSMS) and create a new SSIS project or package.

Mar 13, 2019 · I'm trying to request data from a JSON API from Vemcount - a footfall-sensor system. I want to retrieve all my company's data and store it in a SQL Server db using SSIS.