title: Calling SSIS from Stored Procedure and Returning Variable Values
body: <p>I have a question about how to return values from an SSIS project, that I'm calling from a stored procedure. Is it possible to return SSIS package variables (that I am using to store intermediate results/values/outputs for the SSIS processing) to the stored procedure that is calling the SSIS project in the SSISDB catalog? </p>
  
  <p>Seems like it should be simple to get 'outputs' from an SSIS package call.  Passing parameters into SSIS is a breeze, and is clearly supported. But getting parameters/variables out seems like there is no support in SSIS for getting a parameter/variable as an SSIS output at all... </p>