Community

How to import JSON file into a SQL recordset with OPENJSON

(Jack Vamvas) Question: I have a JSON file loaded daily onto a drive . I need to set up a process to read the JSON file and translate into a SQL recordset.