• we use dtexec, which when run in the context of a scheduler will respond to a kill statement.

    if we kill the job in the scheduler it will kill the ssis package at the point it was processing in about 3 - 4 seconds.