insert json into sqlserver ssis code example
Example: sql server import json
SELECT *
FROM OPENJSON (@JSON, '$.data.assets.parcels')
WITH (id VARCHAR(7),
x INT,
y INT,
price INT '$.auction_price') -- new column name
)SELECT *
FROM OPENJSON (@JSON, '$.data.assets.parcels')
WITH (id VARCHAR(7),
x INT,
y INT,
price INT '$.auction_price') -- new column name
)