SSIS Script Task Error: exception has been thrown by the target of an invocation

Question

I am trying to pass user variables into an SSIS script task to use them in the similarly structured following if clause:-

VariableY= Directory.GetFiles(Dts.Variables("User::VarX").Value.ToString, 
"*.*", SearchOption.TopDirectoryOnly)

For Each VarZ In VariableY
If VarZ.ToString.Contains(Dts.Variables("User::Var1").Value.ToString) Then
localVar = 1
End If

However upon executing it throws and error of the a vague nature with the statement 'exception has been thrown by the target of an invocation'. Previously in the if clause, the values were being hard-coded in the contains() function, which executes smoothly. Any suggestions to solve this?

Edit:- [Error Message]

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

Post the error message. Also, does the directory defined by `User::VarX` exist? — Mazhar, Nov 14 '17 at 14:28
And does the account running the SSIS package have access to that directory? — Brian, Nov 14 '17 at 17:17
What are you trying to do? Attempting to convert VarZ to a String seems unlikely to work. — Tab Alleman, Nov 14 '17 at 19:02
@Tab Alleman. It was working before I changed the code. The previous code in the If clause is structured like this:- If VarZ.ToString.Contains("XYZ_String") Then localVar = 1 — Momin Goni, Nov 15 '17 at 06:13
Also I have updated the Problem with the error message. @Cool_Br33ze — Momin Goni, Nov 15 '17 at 06:17
What is the value of `Var1` at run time, and what is the value of `VarZ.ToString` when the error is encountered? — Tab Alleman, Nov 15 '17 at 14:40
Value of 'Var1 = FileName' and value of 'VarZ.ToString = FileName_Timestamp' @Tab Alleman — Momin Goni, Nov 16 '17 at 06:40
I don't believe you. With those values, your issue is not reproducible. That, or the error is actually occurring in another part of the code you aren't showing. — Tab Alleman, Nov 16 '17 at 19:38

SSIS Script Task Error: exception has been thrown by the target of an invocation

0 Answers0