Поделиться через


Variable Members

Represents a variable on a package, task, or container. This class cannot be inherited.

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

Public Properties

  Имя Description
ms213201.pubproperty(ru-ru,SQL.90).gif CreationName Returns the string that the runtime engine gives when it creates an instance of the Variable object and adds the object to the Variables collection. This property is read-only.
ms213201.pubproperty(ru-ru,SQL.90).gif DataType Returns a TypeCode enumeration that describes the data type of the variable. This property is read-only.
ms213201.pubproperty(ru-ru,SQL.90).gif Description Gets or sets the description for the variable.
ms213201.pubproperty(ru-ru,SQL.90).gif EvaluateAsExpression Gets or sets a Boolean that indicates that the variable contains an expression.
ms213201.pubproperty(ru-ru,SQL.90).gif Expression Gets or sets the expression contained in a variable.
ms213201.pubproperty(ru-ru,SQL.90).gif ID The GUID assigned to the variable. This field is read-only.
ms213201.pubproperty(ru-ru,SQL.90).gif Name Gets or sets the name of the variable.
ms213201.pubproperty(ru-ru,SQL.90).gif Namespace Gets or sets the namespace that the variable belongs to.
ms213201.pubproperty(ru-ru,SQL.90).gif Properties Returns a collection of DtsProperty objects. This property is read-only.
ms213201.pubproperty(ru-ru,SQL.90).gif QualifiedName Gets the fully qualified name of the variable, including the namespace. This property is read-only.
ms213201.pubproperty(ru-ru,SQL.90).gif RaiseChangedEvent A Boolean that indicates if the variable has been flagged to raise the OnVariableValueChanged event when the value of the variable changes.
ms213201.pubproperty(ru-ru,SQL.90).gif ReadOnly Gets or sets a Boolean that indicates that the variable is read-only and cannot have its value modified.
ms213201.pubproperty(ru-ru,SQL.90).gif Site  
ms213201.pubproperty(ru-ru,SQL.90).gif SystemVariable Returns a Boolean that indicates if the variable is a system variable. This property is read-only.
ms213201.pubproperty(ru-ru,SQL.90).gif Value Gets or sets the value assigned to the variable.

В начало

Public Methods

(see also Protected Methods )

  Имя Description
ms213201.pubmethod(ru-ru,SQL.90).gif Dispose This method is inherited from the IDisposable.Dispose method, which is a mechanism to explicitly tell an object to perform cleanup.
ms213201.pubmethod(ru-ru,SQL.90).gif Equals  Overloaded. (inherited from DtsObject )
ms213201.pubmethod(ru-ru,SQL.90).gif GetExpression The GetExpression method is not supported on Variable objects. Use the EvaluateAsExpression property instead.
ms213201.pubmethod(ru-ru,SQL.90).gif GetHashCode  Returns the hash code for this instance. (inherited from DtsObject)
ms213201.pubmethod(ru-ru,SQL.90).gif GetPackagePath Returns the path of the package that the variable belongs to.
ms213201.pubmethod(ru-ru,SQL.90).gif GetType  (inherited from Object )
ms213201.pubmethod(ru-ru,SQL.90).gif LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
ms213201.pubmethod(ru-ru,SQL.90).gifms213201.static(ru-ru,SQL.90).gif op_Equality  (inherited from DtsObject )
ms213201.pubmethod(ru-ru,SQL.90).gifms213201.static(ru-ru,SQL.90).gif op_Inequality  (inherited from DtsObject )
ms213201.pubmethod(ru-ru,SQL.90).gifms213201.static(ru-ru,SQL.90).gif ReferenceEquals  (inherited from Object )
ms213201.pubmethod(ru-ru,SQL.90).gif SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
ms213201.pubmethod(ru-ru,SQL.90).gif SetExpression The SetExpression method is not supported on Variable objects. Use the EvaluateAsExpression property instead.
ms213201.pubmethod(ru-ru,SQL.90).gif ToString  (inherited from Object )

В начало

Protected Methods

  Имя Description
ms213201.protmethod(ru-ru,SQL.90).gif Finalize  (inherited from Object )
ms213201.protmethod(ru-ru,SQL.90).gif MemberwiseClone  (inherited from Object )

В начало

Public Events

  Имя Description
ms213201.pubevent(ru-ru,SQL.90).gif Disposed Adds an event handler to listen to the Disposed event on the Variable.

В начало

См. также

Справочник

Variable Class
Microsoft.SqlServer.Dts.Runtime Namespace