I didn't know you could do this with SSIS, in the past I used this tool to flatten and import JSON data: convert JSON to CSV
Maybe using...