DTS Packages fail when executed from Jobs
- From: "Matt" <mattk@xxxxxxxxxxxxxx>
- Date: Wed, 11 May 2005 03:10:09 -0700
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
.
- Follow-Ups:
- Re: DTS Packages fail when executed from Jobs
- From: Allan Mitchell
- RE: DTS Packages fail when executed from Jobs
- From: Karunakaran
- Re: DTS Packages fail when executed from Jobs
- Prev by Date: Transform Data Task and RowCount delivered
- Next by Date: Re: DTS Package saves ODBC connection details.
- Previous by thread: Transform Data Task and RowCount delivered
- Next by thread: RE: DTS Packages fail when executed from Jobs
- Index(es):
Relevant Pages
|
