dbTalk Databases Forums  

Error running job: "COM Server could not be created"

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Error running job: "COM Server could not be created" in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
bd2103
 
Posts: n/a

Default 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...

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.