Error running job: "COM Server could not be created" -
10-13-2004
, 02:25 PM
I have a DTS Package that executes when I run it manually, but fails when
scheduled as a job, with the following error:
Executed as user: Domain\SomeUser. 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.
I looked online for some help but couldn't find a possible reason for its
failure. The job runs fine everytime I restart the SQL Server and ServerAgent
services, but fails on its next run. The job is extracting data from Active
Directory and my guess is that the failure is memory related. All the DTS
package is doing is running a cmdExec to call an exe.
I have configured the SQL Server service account and my individual account
to be able to launch COM+ applications using the dcomcnfg utility.
Any help will be greatly appreciated... |