Hi,
Two of my jobs failed to execute due to:
Executed as user: CTCBPH_GL2\SQLService. 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 read somewhere that the solution was to restart SQLServerAgent and I did and the problem went away for 2 weeks. However, same error has occurred just today. Restarting the agent seems to work but it doesn't resolve the problem totally.
By the way, the other jobs in the same server are working properly.
Hope somebody can help me with this.
Many thanks in advance! 🙂