I spent a lot of time researching this and tested a handle full of third-party ETL packages. Mongosis would have been a great choice but at the time of testing did not support nested JSON.

My current overall recommendation based on functionality and value is Clover ETL. I find it hard to justify the cost of an additional ETL to use along side SSIS.