So I have an SSIS package that I want to call from a business operation.
For that I am using SQL Outbound operation. However, on trying with ExecuteQuery and ExecuteProcedure Functions, I only see an exeuction ID being generated, but the execution never starts.
I tried two methods:
Executing the SSIS package directly from Execute Query function, but again just execution ID was generated. I could not see the execution in the SSISDB logs.
Executing the SSIS package via a Stored procedure and having ExecuteProcedure trigger the procedure, but same problem.



.jpg)
.png)
.png)
.png)


