Andy Leonard explains various methods of stopping SSIS packages in progress:
Once you have the operation_id value, simply plug it into the stop_operation stored procedure and execute:
exec SSISDB.[catalog].stop_operation @operation_id = 24
The stop_operation stored procedure runs for a few seconds (typically less than 15 seconds) and stops the execution of the SSIS package. SSIS packages that have been stopped are listed with “Canceled” status. You can see operation_id 19 was stopped in the screenshots shown above.
Read on for more.