title: Predicting data with Python script in an SSIS package
body: <p>I'm aware of Microsoft's inclusion of Python in their Machine Learning Services for SQL server, however this is only available for SQL Server 2017 and up, which is a requirement my servers do not currently meet. </p>
  
  <p>With that being the case, I wanted to deploy my generate-predictions-with-trained-model pipeline entirely within SSIS, I.E:</p>
  
  <ol>
  <li>Grab data from my DB</li>
  <li>Pass it to a Python Script Data Flow Task which imports the trained model, generates the predictions and passes them on to the next Data Flow Task</li>
  <li>Write the predictions to the DB</li>
  </ol>
  
  <p>Is there a way to do that entirely within SSIS, or will it be necessary to just use Execute Process Task to kick off the Python script and have that stored separately on the server somewhere?</p>
  
  <p>Cheers</p>