I have a 3GB json
file and I am trying to insert it into a (MS) SQL Server.
SELECT BulkColumn
INTO Temp
FROM OPENROWSET(BULK '##path_to_json_file##', SINGLE_CLOB) as j
I am getting Attempting to grow LOB beyond maximum allowed size of 2147483647 bytes.
I looked, searched, read documentation… but I could not find answer of HOW to load large file into database.
So, it is NOT possible ??? (And yes, I want to insert it all into one single column)