SQL Server Import (Bulk load) JSON file into table

In SQL Server 2016, Microsoft provides built-in support for importing, exporting, parsing, and querying JSON documents or fragments.

In this article, let us see on how to import JSON data into SQL Server table.

Using OPENROWSET is one of the option to bulk load JSON data into SQL Server table.


Say I have JSON data in a folder like shown below:



SELECT ISJSON(BulkColumn) IsValidJson, BulkColumn Json_Col
FROM OPENROWSET (BULK 'C:\JSONFiles\JsonText.json', SINGLE_CLOB) Tmp





Note that there is no specific data type till date to store JSON data.

We can add INSERT statement or SELECT INTO on SELECT using OPENROWSET to load into table.

Microsoft Azure - Move JSON data from another computer to SQL Server instance on VM using SSIS

See Also:


No comments: