SSIS error: Exception has been thrown by the target of an invocation.

• rohitkocharda

  Say Hey Kid

  Points: 687

  More actions

  March 3, 2016 at 2:43 pm

  #325336

  Hi All,

  I created a script task and the task is running fine and doing what it is supposed to do. But after the task ends, I get an error

  Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.NullReferenceException: Object reference not set to an instance of an object.

  at ST_a7e3b170316249f3af1643191c526190.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.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 Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript()

  I checked the script and it has nothing to do with the code in the script. Have you guys seen this kind of error before?

  Thanks

• Tim Mitchell

  SSCoach

  Points: 15685

  More actions

  March 8, 2016 at 4:54 pm

  #1863873

  This is the key part of the message:

  Object reference not set to an instance of an object

  There's an object in your code that is being referenced but has not been instantiated.

  Tim Mitchell
  TimMitchell.net | @tmitch.net | Tyleris.com
  ETL Best Practices