• Identify the SPID and kill it.

    May be you can check these 2 tables msdb.dbo.sysdtspackagelog and msdb.dbo.sysdtssteplog for the status.

    --

    SQLBuddy