How do I kill a DTS package? I have went into the SQL server agent/process info and tried to kill it there, but it did nothing. I have tried to end Enterprise Manager by using the task manager, but when I go back in, the DTS package is still running according to SQL Server Agent.

Thanks for any ideas,
ChelleV

This is executing as a job right ?
Have you tried right clicking on the job and then cancelling there?
Stop SQL Server Agent service?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"ChelleV" <anonymous (AT) discussions (DOT) microsoft.com> wrote

tried to end Enterprise Manager by using the task manager, but when I go
back in, the DTS package is still running according to SQL Server Agent.

If it is a SQL Server Agent job then DTSRun is running. Check Task Manager
for the DTSRun.ex. If it is there then end the process. If it is not
running then the DTS package is not running and something else is going on.

Rand
This posting is provided "as is" with no warranties and confers no rights.

Both of your responses were helpful, I appreciate it

I did actually try to stop and re-start SQLserver agent, and the package still seemed to be running according to Current Process information. Because this was a development box with few users, we rebooted the box, and all is well

However, on most servers we would not have been able to do this, so I'll save your info regarding Task Manager for the future

Thanks again
ChelleV