question

WilliamBurke-1905 avatar image
0 Votes"
WilliamBurke-1905 asked TianyuSun-MSFT commented

VS 2107 SSIS Unknown runtime error

I have migrated several packages to VS2017 Everything work fine tests with out error. Then I added a Configuration file by selecting the configuration option on the properties window. I checked enable Configurations. Selected a existing file. I keep getting this message when the SSIS package runs.

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

Blockquote




vs-debugging
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

WilliamBurke-1905 avatar image
0 Votes"
WilliamBurke-1905 answered TianyuSun-MSFT commented

While the message is cryptic, it was not the message I should have been looking at. if I would have taken a minute to look at my output window I would have seen that the real issue was a missing variable. Once I added it to my input variables the message went away

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @WilliamBurke-1905 , welcome to Microsoft Q&A forum. Happy to know that this error went away, feel free to let us know if you meet other issues in the future, have a nice day.

0 Votes 0 ·