I have scheduled a dts package and i am getting an error with the following
error code and description.

error code : 80040E14
error description : Only user processes can be killed.
Error Source: Microsoft OLE DB Provider for SQL Server

can anybody help me please . this is very urgent.
Thanks
BL

Is anything in your package trying to kill processes? The error would seem
fairly obvious in those circumstances.

If not, what exactly is in your package?

If this really is urgent then perhaps it would be worth paying for Microsoft
Support?

--
Darren Green
http://www.sqldts.com

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

The error says to me that you are trying to kill a system process, in
other words a process that is not a user process hence the error says
this is not allowed. You cannot kill system process.

If you are not sure why this is happening I suggest you dump
sysprocesses or the ouput of sp_who2 to a file before starting the kill,
and also log the kill commands you attempt so you can check this out in
the morning.

Make sense?

Darren


In message <1FA402DB-D575-4B5A-8C7D-8EAF198225F4 (AT) microsoft (DOT) com>, bl
<bl (AT) discussions (DOT) microsoft.com> writes
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org