title: Reading JSON file into a table
body: <p>I am trying to read JSON files from a location and write to SQL server table. The files in the location change everyday, as a result I may need to find a dynamic way to select file name.</p>
  
  <p>I have tried to use the <code>OPENROWSET</code>, however I read that I cannot parametize the location name with that. I tried to use <code>OPENROWSET</code> with a dynamic query but I get an error that file location can not be found. After reading about it seems it could be a folder permission issue.</p>
  
  <p>What I am not trying and hoping to get help with is how I can read the JSON text file and write the data into a table and then I can use the <code>OPENJSON</code> function from there.</p>
  
  <p>Can anyone help me with how I can load a SQL server with the JSON data in some sort of a blob using T-SQL or SSIS.</p>