Variable-Klasse
Represents a variable on a package, task, or container. This class cannot be inherited.
Vererbungshierarchie
System. . :: . .Object
Microsoft.SqlServer.Dts.Runtime. . :: . .DtsObject
Microsoft.SqlServer.Dts.Runtime..::..Variable
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
Syntax
'Declaration
Public NotInheritable Class Variable _
Inherits DtsObject _
Implements IDTSPersist, IDTSName, IDTSPropertiesProvider, IDTSPackagePath, _
IComponent, IDisposable
'Usage
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
Der Variable-Typ macht folgende Elemente verfügbar.
Eigenschaften
Name | Beschreibung | |
---|---|---|
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 | Infrastruktur | |
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. |
Zum Anfang
Methoden
Name | Beschreibung | |
---|---|---|
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. (Geerbt von DtsObject.) | |
Finalize | (Geerbt von Object.) | |
GetExpression | The GetExpression method is not supported on Variable objects. Use the EvaluateAsExpression property instead. | |
GetHashCode | Returns the hash code for this instance. (Geerbt von DtsObject.) | |
GetPackagePath | Returns the path of the package that the variable belongs to. | |
GetType | (Geerbt von Object.) | |
LoadFromXML | This method is not callable by your application code. To load a package saved as .xml, use the Application..::..LoadPackage method. | |
MemberwiseClone | (Geerbt von 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 | (Geerbt von Object.) |
Zum Anfang
Ereignisse
Name | Beschreibung | |
---|---|---|
Disposed | Adds an event handler to listen to the Disposed event on the Variable. |
Zum Anfang
Hinweise
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:
Threadsicherheit
Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.