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. This error happens when the client tries to retrieve an element from a collection on a container during execution of the package and the element isn't there.

Community Notes

This is similar to an IndexOutOfRangeException exception. An example of this error would be when trying to retrieve a custom properyy (IDTSCustomProperty90) from a custom property collection (IDTSCustomPropertyCollection90), if that property does not exist.

The code below attempts to retrieve the value of a custom property called NameOfProperty. If that property does not exist then this error will be raised.

 object propertyValue = ComponentMetaData.CustomPropertyCollection["NameOfProperty"].Value

The target of this exception should support the explanation above, so Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSCustomPropertyCollection90.get_Item(Object Index) indicates that it is indeed happening when you try and read the property value.

RuntimeErrorCodes