title: How to create a SSIS package to ETL JSON from Python REST API request into MSSQL server?
body: <p>I am trying to take a Python script I wrote that makes <code>GET</code> requests utilizing a REST API and returns data in the form of JSON and then have that data be inserted into a SQL server that I will have to create.</p>
  
  <p>This job will need to run each day at least once.  I am not familiar with creating tables in MSSQL let alone creating a SSIS package or working with ETL.  </p>
  
  <p>I would appreciate some direction as to how to do this and how realistic it is for somebody with little actual experience, but a good understanding of the process itself conceptually.</p>
  
  <p>My end goal is to import this data into a Power BI file for live reporting.</p>