Clase Variable

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

Jerarquía de herencia

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

Espacio de nombres:  Microsoft.SqlServer.Dts.Runtime
Ensamblado:  Microsoft.SqlServer.ManagedDTS (en Microsoft.SqlServer.ManagedDTS.dll)

Sintaxis

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

El tipo Variable expone los siguientes miembros.

Propiedades

	Nombre	Descripción
	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	Infraestructura.
	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.

Arriba

Métodos

	Nombre	Descripción
	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. (Se hereda de DtsObject.)
	Finalize	(Se hereda de Object.)
	GetExpression	The GetExpression method is not supported on Variable objects. Use the EvaluateAsExpression property instead.
	GetHashCode	Returns the hash code for this instance. (Se hereda de DtsObject.)
	GetPackagePath	Returns the path of the package that the variable belongs to.
	GetType	(Se hereda de Object.)
	LoadFromXML	This method is not callable by your application code. To load a package saved as .xml, use the Application..::..LoadPackage method.
	MemberwiseClone	(Se hereda de 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	(Se hereda de Object.)

Arriba

Eventos

	Nombre	Descripción
	Disposed	Adds an event handler to listen to the Disposed event on the Variable.

Arriba

Comentarios

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:

• IComponent

• IDisposable

Seguridad para subprocesos

Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.

Vea también

Referencia

Espacio de nombres Microsoft.SqlServer.Dts.Runtime