Condividi tramite


Classe Variable

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

Gerarchia di ereditarietà

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

Spazio dei nomi  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Sintassi

'Dichiarazione
Public NotInheritable Class Variable _
    Inherits DtsObject _
    Implements IDTSPersist, IDTSName, IDTSPropertiesProvider, IDTSPackagePath,  _
    IComponent, IDisposable
'Utilizzo
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

Nel tipo Variable sono esposti i membri seguenti.

Proprietà

  Nome Descrizione
Proprietà pubblica 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.
Proprietà pubblica DataType Returns a TypeCode enumeration that describes the data type of the variable. This property is read-only.
Proprietà pubblica Description Gets or sets the description for the variable.
Proprietà pubblica EvaluateAsExpression Gets or sets a Boolean that indicates that the variable contains an expression.
Proprietà pubblica Expression Gets or sets the expression contained in a variable.
Proprietà pubblica ID The GUID assigned to the variable. This field is read-only.
Proprietà pubblica 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.
Proprietà pubblica Name Gets or sets the name of the variable.
Proprietà pubblica Namespace Gets or sets the namespace that the variable belongs to.
Proprietà pubblica Properties Returns a collection of DtsProperty objects. This property is read-only.
Proprietà pubblica QualifiedName Gets the fully qualified name of the variable, including the namespace. This property is read-only.
Proprietà pubblica RaiseChangedEvent A Boolean that indicates if the variable has been flagged to raise the OnVariableValueChanged event when the value of the variable changes.
Proprietà pubblica ReadOnly Gets or sets a Boolean that indicates that the variable is read-only and cannot have its value modified.
Proprietà pubblica Site Infrastruttura.
Proprietà pubblica SystemVariable Returns a Boolean that indicates if the variable is a system variable. This property is read-only.
Proprietà pubblica Value Gets or sets the value assigned to the variable.

In alto

Metodi

  Nome Descrizione
Metodo pubblico Dispose This method is inherited from the IDisposable.Dispose method, which is a mechanism to explicitly tell an object to perform cleanup.
Metodo pubblico Equals Determines whether two object instances are equal. Ereditato da DtsObject.
Metodo protetto Finalize Ereditato da Object.
Metodo pubblico GetExpression The GetExpression method is not supported on Variable objects. Use the EvaluateAsExpression property instead.
Metodo pubblico GetHashCode Returns the hash code for this instance. Ereditato da DtsObject.
Metodo pubblico GetPackagePath Returns the path of the package that the variable belongs to.
Metodo pubblico GetType Ereditato da Object.
Metodo pubblico LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application..::..LoadPackage method.
Metodo protetto MemberwiseClone Ereditato da Object.
Metodo pubblico SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application..::..SaveToXml method.
Metodo pubblico SetExpression The SetExpression method is not supported on Variable objects. Use the EvaluateAsExpression property instead.
Metodo pubblico ToString Ereditato da Object.

In alto

Eventi

  Nome Descrizione
Evento pubblico Disposed Adds an event handler to listen to the Disposed event on the Variable.

In alto

Osservazioni

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:

Protezione dei thread

I membri static (Shared in Visual Basic) pubblici di questo tipo sono affidabili. Non è invece garantita la sicurezza dei membri dell'istanza.