I have a sql 2008R2 job set up to execute an ssis package to retrieve results from a mailchimp web service and output an Excel report.
When I run the job manually,it succeeds. When the job runs with schedule time if fails with the below error.
Message Executed as user: MSSQL\AdminInstall. Microsoft (R) SQL Server Execute Package Utility Version 10.50.6000.34 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 9:52:48 AM Error: 2017-10-13 09:52:49.27 Code: 0x00000001
Source: Create First Tab Description: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException (0x8000401A): Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 8000401a. at ST_0430d5d8b7004631b82752eaf579afb5.csproj.ScriptMain.Main() --- End of inner exception stack trace --- at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams) at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args, CultureInfo culture) at Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript() End Error DTExec: The package execution returned DTSER_SUCCESS (0). Started: 9:52:48 AM Finished: 9:52:49 AM Elapsed: 0.765 seconds. The package executed successfully. The step succeeded.
I have the job steps set to run with a proxy user.
Can any shed any light on this?
Is there a reason why the job succeeds when can run the job manually, but fails on the schedule time?
User contributions licensed under CC BY-SA 3.0