107 How to load json file in SSIS | Import json file to SQL Server using SSIS

How do I import a JSON file into SQL Server?

Download the file\script used in the Video from below link

How do I import a JSON file into SQL Server?
How do I import a JSON file into SQL Server?
Can SSIS handle JSON?
How do I load a JSON file?
How do I import JSON files into Visual Studio?
What opens a JSON file?
How do I import JSON into SQL Developer?
Import json file to sql server using SSIS

Happy Learning.

[syfdknw]

Another approach to take without script component is to read file contents into varchar variable and than feed it into plain vanilla sql insert wich uses OpenJson statement.

[darbardarbar]

Excellent teaching way
Thanks for sharing your knowledge

[dfkbthv]

Thanks a lot for such a wonderful video, appreciate

[kssabin]

It works, Thanks for this video, Very useful ! 😊

[rajugrg]

how to load alternate rows in to the destination by using SSIS

[lb]

I did exactly the same operation but unfortulatly the list is always empty do you have any idea please ?

[jegadeesr]

It's really nice one and cleared my doubts. Can you please make a video for nested array json file if possible?

[abdullahmusheer]

Hi great video very helpful. My question is: in the code part whwre you changed the object to obj, can you name it anything? What was the logic? And also I have to download json data from api with basic authentication.Can you make a video explaining it?

[abebetaye]

It helps a lot. Thank you. But what if we have multiple JSON files? Would you please make a video on how to load multiple JSON files using script component?

[jonaskarlsson]

It was good i have used this long time. But the problem for SSIS is how to handel like the person have array of email. How do i create a new Fcttable or DImTable with
Id, firstname;lastname, Gender
and the other table
Id, Email so i cant have multiply email to a Id

[agamyashastha]

same approach, i have followed to load JSON onto postgressql where connection is successful, but I m facing error as follows:
TITLE: Microsoft Visual Studio


Exception from HRESULT: 0xC020204A
Error at Data Flow Task [ODBC Destination [132]]: SQLSTATE: 42703, Message: ERROR: column "assd???" does not exist;
No query has been executed with that handle;
Error at Data Flow Task [ODBC Destination [132]]: Unable to retrieve column information from the data source. Make sure your target table in the database is available.




BUTTONS:

OK

[Chris-njeq]

I am running into this error message: System.ArgumentException: Error during serialization or deserialization using the JSON JavaScriptSerializer. The length of the string exceeds the value set on the maxJsonLength property.

Where do I go to adjust maxJsonLength?

[vinny]

I am getting "Error during serialization or deserialization using the JSON JavaScriptSerializer. The length of the string exceeds the value set on the maxJsonLength property.
Parameter name: input"

How do i fix this?

[mangaiyarkarasisivakolunth]

Can we create destination as two ms-sql with foreign key reference

[vygipto]

Hi, Great Video. Thank you. and I am facing the issue like (The binary code for the script is not found click edit. Could you please guide me to resolve is issue.

[olcmjdq]

akil i have a json file with like 50 keys. there must be some other way to add these columns

[ghadaas]

Hi, Thank you for the video but if my json file is like the code bellow how do i write my script
{
"data": {
"customers": [
{
"city": "city2",
"name": "client1"
},
{
"city": "city1",
"name": "client2"
}
]
}
}

[monishbevinraj]

what if the jason file is placed in different server and how can we give path as parameters..

[maham]

Can you make a video of how to read Kafka topic in SSIS

[Loknath]

Hi,
Could you give me solution for below scenario

When we are dealing with huge amount of data(10milion records) will go with bulk insert task batch wise, but if one row having issue then that batch records will not load right.. so keepon doing this failed data will increase.. so how to overcome this..?