dbTalk Databases Forums  

Cannot create COM Server to load and execute DTS Package

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


Discuss Cannot create COM Server to load and execute DTS Package in the microsoft.public.sqlserver.dts forum.



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

Default Cannot create COM Server to load and execute DTS Package - 03-16-2005 , 12:56 PM






I am now suddenly plagued by this problem. Stopping and re-starting Sql
Server and the Agent service allows the jobs to run successfully again, but
they will only run at their scheduled time once successfully, then they fail
the second time. Then I have to repeat the process. I can't find any info
anywhere on this problem. Does anyone have any ideas how to get somewhere
with this issue? Here is the error message received:

DTSRun: Cannot create COM Server to load and execute DTS Package. Error
-2147023782 (8007045A): A dynamic link library (DLL) initialization routine
failed. Process Exit Code -2147023782. The step failed.

This process is running from an Agent job, and the service account for Agent
has System Admin privileges.

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.