'Invalid object name 'OPENJSON'.' - SQL Server doesn't recognise OPENJSON when bulk importing files

added by DotNetKicks
12/10/2018 2:46:42 PM

1 Kicks, 642 Views

Recently I've been working with the GIS extensions in SQL Server, and Ineeded to import a GeoJSON file into a SQL Server 2017 table. There's a very straightforward way to import a valid JSON file into SQL Server with the OPENROWSET command, as shown below.