Loading data from multiple JSON files to SQL Server Table | SSIS | SQL Server Integration Services

Описание

In this video, we will see how can we load data from multiple JSON files to SQL Server Table | SSIS | SQL Server Integration Services.

Query/Expression to Load JSON File================================
"Declare @EmployeesJSON varchar(max)
SELECT @EmployeesJSON = BulkColumn
FROM OPENROWSET (BULK '"+ @[User::FullJsonFilePath] +"', SINGLE_CLOB) import
--INSERT INTO dbo.EmployeesJSON
SELECT *
FROM OPENJSON (@EmployeesJSON)
WITH
(
[id] int,
[first_name] varchar(50),
[last_name] varchar(50),
[email] varchar(50),
[gender] nvarchar(30),
[city] varchar(100),
[country] varchar(100),
[JsonFileName] varchar(50)
)"
CREATE TABLE========================================
CREATE TABLE [dbo].[EmployeesJSON]
(
[id] int,
[first_name] varchar(50),
[last_name] varchar(50),
[email] varchar(50),
[gender] nvarchar(30),
[city] varchar(100),
[country] varchar(100),
[JsonFileName] varchar(50)
)


You can find me on
1-https://www.linkedin.com/in/satyarth-rao-5baba016a
2-https://www.instagram.com/satyarthrao/
3-https://twitter.com/RaoSatyarth
4-https://www.facebook.com/SatyarthProgrammingHub
5-https://github.com/Satyarth-Programming-Hub