title: SSIS and JSON Flat Files
body: <p>Whats the best way to get JSON flat files into SQL Server using SSIS?</p>
  
  <p>Currently I've tried parsing the data in a script component, but with amount of JSON files I'm parsing (around 120 at a time) it takes upward of 15 minutes to get the data in. I also don't consider this very practical. </p>
  
  <p>Is there a way to combine the powers of SSIS and the OPENJSON command in SQL server? I'm running SQL server 2016 so I'm trying to leverage that command in the hopes that it works faster. </p>
  
  <p>Also, I have no problem getting the JSON data in without losing format. 
  Looks like this: </p>
  
  <p><a href="https://i.stack.imgur.com/pC3vu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pC3vu.png" alt="JSON Example"></a></p>
  
  <p>Is there a way for me to leverage that and get JSON format into a more Normalized format. </p>