Re: How to troubleshoot a SQL Server 80040E14

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: bl (bl_at_discussions.microsoft.com)
Date: 08/10/04 

Date: Tue, 10 Aug 2004 09:57:03 -0700

Darren,
Yes, the dts is basically used to kill processes that try to connect to the
production sql server during the load time (late night).
This works alright on development box and also works alright during weekend
inthe production box, but fails during weekdays.
I am thinking that some other process trys to kill this process. I am not
sure what the error message says .
Can you help?
BL

"Darren Green" wrote:

> 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@discussions.microsoft.com> wrote in message
> news:4AE4AB44-5AB5-4C30-AB3C-73981F24F492@microsoft.com...
> > 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
>
>
>

Relevant Pages

  • dts import with utf-8?
    ... we have some dts packages on a production sql server, ... My country is Greece so a lot of greek characters are included in ... unicode format (2 bytes per character) and everything was ok. ... In the dts designer, i tried to change the expected file format of the input ...
    (microsoft.public.sqlserver.dts)
  • Re: Cannot immediately select after executing DTS
    ... The scenario is ... applicable to the table used in the DTS. ... Selecting from other tables is ... alright. ...
    (microsoft.public.sqlserver.dts)