If it's SSIS 2012, you can very easily start SSIS packages with parameters using stored procedures, so I would look into that route. I believe you can also run the SSIS packages synchronously if you'd like.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP