Variables.Contains Method

Returns a Boolean that indicates whether the items in the collection can be accessed by using indexing without throwing an exception.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

bool Contains (
	Object^ index
public boolean Contains (
	Object index
public function Contains (
	index : Object
) : boolean



The name, ID, description, or index of the variable to locate in the collection.

Return Value

A Boolean that indicates whether the collection can be accessed by using indexing. A value of true indicates that the collection can be accessed by using the syntax Variables[index]. If the Contains method returns false, this property will throw an exception. In C#, this property is the indexer for the Variables class.

The following code example adds a variable to the package. The code example uses various methods to locate the variable and print out its name, value, and namespace.

No code example is currently available or this language may not be supported.

Sample Output:

The variable was found? True

Variable: myCustomVar, 3


[0] myCustomVar, User


The name and namespace of the first variable is: CancelEvent, System

The name of the first variable is: CancelEvent

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions