Can we stop a forever-running package in SSIS? If yes, how?
Yes, you can stop a forever-running package, but it depends on where the package is running. If the package is running within the SQL Agent, you can kill the entire process using T-SQL. But if the package is running within the SSIS catalog, you need to use the stop-operation method. Apart from this, you can use the Active operations window to stop the SSIS catalog’s running process.
