In that earlier column, I looked at why you might want to do that and handled the simple case: Converting single-value properties in a JSON object into a row in a table (or multiple rows where you ...

Here's how you can use SQL Server's OpenJson function to dismantle JSON structures into relational tables targeting either transactional systems or data warehouses. JSON is great for moving data ...

The final thing you will want to do here is to convert the JSON data to a table. Do this by clicking on Into Table, then hit Close & Load. You should now see the data from within the JSON file ...