SSIS Common Error

Below message is a common error that I encountered when debugging on SSIS package – Script Task:

System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)    
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)    
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()

Upon checking, basically there are two possibilities:

  1. The read variable or read-only variable that use in C# code is not available, we have to select it through advance settings there.
  2. External assemblies are not registered in GAC, please perform gacutil /i

Leave a Reply

Your email address will not be published. Required fields are marked *