trying to collect all ssis errors into one variable in Script task at the end of SSIS 2008 /BIDS package, problem..

• VoldemarG

  Hall of Fame

  Points: 3883

  More actions

  July 20, 2016 at 1:16 pm

  #315427

  The below VB.net code that I try to use in Script Task produces error: (how can i derive useful info from this error messages?)

  Is this because Dts.Variables("ErrorDescription") does not exist in BIDS 2008 R2 /ssis 2008?

  I passed variable errorMessagesF into the script task as read/write variable.

  Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: The element cannot be found in a collection. This error happens when you try to retrieve an element from a collection on a container during execution of the package and the element is not there.

  ---> System.Runtime.InteropServices.COMException (0xC0010009): The element cannot be found in a collection. This error happens when you try to retrieve an element from a collection on a container during execution of the package and the element is not there.

  at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSVariables100.get_Item(Object Index)

  at Microsoft.SqlServer.Dts.Runtime.Variables.get_Item(Object index)

  --- End of inner exception stack trace ---

  at Microsoft.SqlServer.Dts.Runtime.Variables.get_Item(Object index)

  at ST_b01f9d9d654f4f269f830e1d2b500b98.vbproj.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()

  Public Sub Main()

  Dim messages As Collections.ArrayList

  Try

  messages = CType(Dts.Variables("errorMessagesF").Value, Collections.ArrayList)

  Catch ex As Exception

  messages = New Collections.ArrayList()

  End Try

  messages.Add(Dts.Variables("ErrorDescription").Value.ToString())

  Dts.TaskResult = ScriptResults.Success

  End Sub

  Likes to play Chess