Udostępnij za pośrednictwem


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

  Name Description
ms213201.pubproperty(en-US,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(en-US,SQL.90).gif DataType Returns a TypeCode enumeration that describes the data type of the variable. This property is read-only.
ms213201.pubproperty(en-US,SQL.90).gif Description Gets or sets the description for the variable.
ms213201.pubproperty(en-US,SQL.90).gif EvaluateAsExpression Gets or sets a Boolean that indicates that the variable contains an expression.
ms213201.pubproperty(en-US,SQL.90).gif Expression Gets or sets the expression contained in a variable.
ms213201.pubproperty(en-US,SQL.90).gif ID The GUID assigned to the variable. This field is read-only.
ms213201.pubproperty(en-US,SQL.90).gif Name Gets or sets the name of the variable.
ms213201.pubproperty(en-US,SQL.90).gif Namespace Gets or sets the namespace that the variable belongs to.
ms213201.pubproperty(en-US,SQL.90).gif Properties Returns a collection of DtsProperty objects. This property is read-only.
ms213201.pubproperty(en-US,SQL.90).gif QualifiedName Gets the fully qualified name of the variable, including the namespace. This property is read-only.
ms213201.pubproperty(en-US,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(en-US,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(en-US,SQL.90).gif Site  
ms213201.pubproperty(en-US,SQL.90).gif SystemVariable Returns a Boolean that indicates if the variable is a system variable. This property is read-only.
ms213201.pubproperty(en-US,SQL.90).gif Value Gets or sets the value assigned to the variable.

Top

Public Methods

(see also Protected Methods )

  Name Description
ms213201.pubmethod(en-US,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(en-US,SQL.90).gif Equals  Overloaded. (inherited from DtsObject )
ms213201.pubmethod(en-US,SQL.90).gif GetExpression The GetExpression method is not supported on Variable objects. Use the EvaluateAsExpression property instead.
ms213201.pubmethod(en-US,SQL.90).gif GetHashCode  Returns the hash code for this instance. (inherited from DtsObject)
ms213201.pubmethod(en-US,SQL.90).gif GetPackagePath Returns the path of the package that the variable belongs to.
ms213201.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms213201.pubmethod(en-US,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(en-US,SQL.90).gifms213201.static(en-US,SQL.90).gif op_Equality  (inherited from DtsObject )
ms213201.pubmethod(en-US,SQL.90).gifms213201.static(en-US,SQL.90).gif op_Inequality  (inherited from DtsObject )
ms213201.pubmethod(en-US,SQL.90).gifms213201.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms213201.pubmethod(en-US,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(en-US,SQL.90).gif SetExpression The SetExpression method is not supported on Variable objects. Use the EvaluateAsExpression property instead.
ms213201.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )

Top

Protected Methods

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

Top

Public Events

  Name Description
ms213201.pubevent(en-US,SQL.90).gif Disposed Adds an event handler to listen to the Disposed event on the Variable.

Top

See Also

Reference

Variable Class
Microsoft.SqlServer.Dts.Runtime Namespace