SQL Server is reading only first row from valid JSON

Viewed 3467

My JSON is like below. This JSON is read by ADF without problem and imports all rows.

{"Row":{"Col1":"Val1", "Col2":"Val2"}}
{"Row":{"Col1":"Val1", "Col2":"Val2"}}
{"Row":{"Col1":"Val1", "Col2":"Val2"}}

However when I read this from SQL using below query, it returns only first record.

SELECT * FROM OPENJSON(@JSONDATA, '$')
with (
    Col1 varchar(25) '$.Row.Col1'
);

Do you know why?

2 Answers
Related