Thank you for your reply. So using Json source connector is not easy way of doing it ?
I will try to use phython or I can use visual studio project to read data from json and dump that in SQL and create a package from there.
it might be a bit of work around but will see.