Phil Parkin (8/24/2016)
Manic Star (8/24/2016)
Powershell! Its very easy to work with Json in Powershell.Would you care to elaborate on how you have integrated a PoSh solution into an SSIS package or packages?
Not SSIS, but you can schedule a script in SQL Agent.