共用方式為


Variable 類別

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

繼承階層

System. . :: . .Object
  Microsoft.SqlServer.Dts.Runtime. . :: . .DtsObject
    Microsoft.SqlServer.Dts.Runtime..::..Variable

命名空間:  Microsoft.SqlServer.Dts.Runtime
組件:  Microsoft.SqlServer.ManagedDTS (在 Microsoft.SqlServer.ManagedDTS.dll 中)

語法

'宣告
Public NotInheritable Class Variable _
    Inherits DtsObject _
    Implements IDTSPersist, IDTSName, IDTSPropertiesProvider, IDTSPackagePath,  _
    IComponent, IDisposable
'用途
Dim instance As Variable
public sealed class Variable : DtsObject, 
    IDTSPersist, IDTSName, IDTSPropertiesProvider, IDTSPackagePath, IComponent, 
    IDisposable
public ref class Variable sealed : public DtsObject, 
    IDTSPersist, IDTSName, IDTSPropertiesProvider, IDTSPackagePath, IComponent, 
    IDisposable
[<SealedAttribute>]
type Variable =  
    class
        inherit DtsObject
        interface IDTSPersist
        interface IDTSName
        interface IDTSPropertiesProvider
        interface IDTSPackagePath
        interface IComponent
        interface IDisposable
    end
public final class Variable extends DtsObject implements IDTSPersist, IDTSName, IDTSPropertiesProvider, IDTSPackagePath, IComponent, IDisposable

Variable 型別公開下列成員。

屬性

  名稱 說明
公用屬性 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.
公用屬性 DataType Returns a TypeCode enumeration that describes the data type of the variable. This property is read-only.
公用屬性 Description Gets or sets the description for the variable.
公用屬性 EvaluateAsExpression Gets or sets a Boolean that indicates that the variable contains an expression.
公用屬性 Expression Gets or sets the expression contained in a variable.
公用屬性 ID The GUID assigned to the variable. This field is read-only.
公用屬性 IncludeInDebugDump Gets or sets a value that specifies whether the variable value for a user-defined variable or a system variable is included in the debug dump files.
公用屬性 Name Gets or sets the name of the variable.
公用屬性 Namespace Gets or sets the namespace that the variable belongs to.
公用屬性 Properties Returns a collection of DtsProperty objects. This property is read-only.
公用屬性 QualifiedName Gets the fully qualified name of the variable, including the namespace. This property is read-only.
公用屬性 RaiseChangedEvent A Boolean that indicates if the variable has been flagged to raise the OnVariableValueChanged event when the value of the variable changes.
公用屬性 ReadOnly Gets or sets a Boolean that indicates that the variable is read-only and cannot have its value modified.
公用屬性 Site 基礎結構。
公用屬性 SystemVariable Returns a Boolean that indicates if the variable is a system variable. This property is read-only.
公用屬性 Value Gets or sets the value assigned to the variable.

上層

方法

  名稱 說明
公用方法 Dispose This method is inherited from the IDisposable.Dispose method, which is a mechanism to explicitly tell an object to perform cleanup.
公用方法 Equals Determines whether two object instances are equal. (繼承自 DtsObject。)
受保護的方法 Finalize (繼承自 Object。)
公用方法 GetExpression The GetExpression method is not supported on Variable objects. Use the EvaluateAsExpression property instead.
公用方法 GetHashCode Returns the hash code for this instance. (繼承自 DtsObject。)
公用方法 GetPackagePath Returns the path of the package that the variable belongs to.
公用方法 GetType (繼承自 Object。)
公用方法 LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application..::..LoadPackage method.
受保護的方法 MemberwiseClone (繼承自 Object。)
公用方法 SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application..::..SaveToXml method.
公用方法 SetExpression The SetExpression method is not supported on Variable objects. Use the EvaluateAsExpression property instead.
公用方法 ToString (繼承自 Object。)

上層

事件

  名稱 說明
公用事件 Disposed Adds an event handler to listen to the Disposed event on the Variable.

上層

備註

Variables are grouped into namespaces for disambiguation. The System namespace is created automatically for every package and contains read-only properties. The User namespace contains custom properties that you can add. You can also create a namespace of your choosing to which to add variables. This class inherits from several classes and interfaces, including two from the Visual Studio .NET Framework:

執行緒安全性

這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。