Below are some useful articles which will help you to start.
1 - SSIS JSON
2-SSIS ElasticSearch

Hope this helps...

Go to with following article called SSIS JSON.
Which support for SQL Server 2005,2008,2012,2016 and 2017(32 bit / 64 bit)

February 23, 2018 at 9:26 am

#1980958