Share via

VariablesCollection Members

  • Article

Contains a collection of PkgVariable objects, representing the inner or outer variables of a Microsoft SQL Server 2000 Data Transformation Services (DTS) package to be executed by the Exec80PackageTask.

The following tables list the members exposed by the VariablesCollection type.

Public Constructors

  Name Description
VariablesCollection Initializes a new instance of VariablesCollection.

Top

Public Properties

  Name Description
ms214826.pubproperty(en-US,SQL.90).gif Count Gets the number of elements contained in the collection.
ms214826.pubproperty(en-US,SQL.90).gif IsSynchronized Gets a value indicating whether access to the collection is synchronized (thread-safe).
ms214826.pubproperty(en-US,SQL.90).gif SyncRoot Gets an object that can be used to synchronize access to the collection.

Top

Public Methods

(see also Protected Methods )

  Name Description
ms214826.pubmethod(en-US,SQL.90).gif Add Creates and adds a PkgVariable to the end of the collection.
ms214826.pubmethod(en-US,SQL.90).gif Clear Removes all elements from the collection.
ms214826.pubmethod(en-US,SQL.90).gif CopyTo Copies the entire collection to a compatible one-dimensional Array, starting at the specified index of the target array.
ms214826.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms214826.pubmethod(en-US,SQL.90).gif GetElement Overloaded. Gets an element from the collection.
ms214826.pubmethod(en-US,SQL.90).gif GetEnumerator Returns an enumerator that can iterate through the collection.
ms214826.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms214826.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms214826.pubmethod(en-US,SQL.90).gifms214826.static(en-US,SQL.90).gif LoadFromString Creates and adds one or more elements, from a delimited string, to the end of the collection.
ms214826.pubmethod(en-US,SQL.90).gifms214826.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms214826.pubmethod(en-US,SQL.90).gif Remove Removes the element with the specified index from the collection
ms214826.pubmethod(en-US,SQL.90).gif ToString Overridden. Returns a delimited string that represents the contents of the collection.

Top

Protected Methods

  Name Description
ms214826.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms214826.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

See Also

Reference

VariablesCollection Class
Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask Namespace