Re: DTS Packages fail when executed from Jobs

Tech-Archive recommends: Fix windows errors by optimizing your registry

I don't think it is related to this article.

I have tried running the DTS package on the server whilst logged on as the
SQL Agent account and it also works when run from the command line with
DTSRUN.EXE or through the SQL Server Enterprise Manager.

It still fails when executed from a Job.

I've also noticed that another job which just runs an ActiveX Script is
failing with the following message:

Executed as user: domain\username. Error Code: 0 Error Source= Microsoft
VBScript runtime error Error Description: Out of memory Error on Line 2.
The step failed.

The server is certainly not out of memory by far.


"Allan Mitchell" wrote:

> Are you not experiencing this
>
> http://support.microsoft.com/?kbid=269074
>
>
>
>
>
>
> "Matt" <mattk@xxxxxxxxxxxxxx> wrote in message
> news:mattk@xxxxxxxxxxxxxx:
>
> > I am having trouble executing a DTS package from a SQL Job. It works OK for a
> > while but then starts failing with the following error message:
> >
> > Executed as user: domain\SQLSvcAccount. DTSRun: Cannot create COM Server to
> > load and execute DTS Package. Error -2147221008 (800401F0): CoInitialize
> > has not been called. Process Exit Code -2147221008. The step failed.
> >
> > To correct this I need to restart the SQL services.
> >
> > I can run the DTS Package directly using Enterprise Manager from my PC and I
> > can also using the DTSRUN.exe command to execute the package from my PC using
> > the exact command line that the SQL job is using. This works OK, even when
> > the jobs are failing.
> >
> > Can anyway shed any light on this and come up with a solution?
> >
> > In brief, my setup is SQL 2000 with SP3 running on Windows Server 2003.
> >
> > Thanks
> > Matt
>
>
.

Relevant Pages

  • global variable not working
    ... which sets a global variable in the DTS package and then the stored procedure ... It all works on the development server! ... problem I am having is that I have moved the DTS package up to our Test sql ...
    (microsoft.public.sqlserver.dts)
  • RE: Multiple loops in one package?
    ... this is not currently support in SQL 2000 DTS package. ... | I know how to loop through one set, but wasn't sure if there was an easy ... | Get next server from Server recordset --a ...
    (microsoft.public.sqlserver.dts)
  • Re: Lookup executes 3 time upon Recordset.Save
    ... client side cursor and the SQL is now only executed once. ... executing my code three times (the code below is simplified fro ... > and {SQL Server} drivers): ...
    (microsoft.public.data.ado)
  • RE: DTS, .NET and remote servers
    ... Server A is running SQL 2000 and in domain X ... Server B is running IIS and host web-sevvice, ... I wish my web-service to trigger a DTS import on server A. The ... demonstrating the DTS package is loaded and accessible on Server B). ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Package fails from CMD prompt
    ... The DTS Package partially completes when I run it through DTSRUN from my ... FOXPRO UNC connections fails. ... The DTS package was created at the Server on which it runs. ... DTSRun: Executing... ...
    (microsoft.public.sqlserver.dts)