Was curious if anyone has used Service Connect to fire up a SSIS package from the console?
You can try to prepare SQL script for same and call in DB component.
While there’s probably a way to have SC start a program, I’d rather suggest doing that through DB Operation.
Here’s the article (I did not try that myself) that walks through the creation of the stored procedure that initiates the execution of an SSIS package; that stored procedure could be called from SC’s DB Operation element on the workflow to initiate SSIS execution:
The article mentions that SSIS package execution is asynchronous.