다음을 통해 공유


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,  _
    IDTSExecutionPath, IComponent, IDisposable
‘사용 방법
Dim instance As Variable
public sealed class Variable : DtsObject, 
    IDTSPersist, IDTSName, IDTSPropertiesProvider, IDTSPackagePath, IDTSExecutionPath, 
    IComponent, IDisposable
public ref class Variable sealed : public DtsObject, 
    IDTSPersist, IDTSName, IDTSPropertiesProvider, IDTSPackagePath, IDTSExecutionPath, 
    IComponent, IDisposable
[<SealedAttribute>]
type Variable =  
    class 
        inherit DtsObject 
        interface IDTSPersist 
        interface IDTSName 
        interface IDTSPropertiesProvider 
        interface IDTSPackagePath 
        interface IDTSExecutionPath 
        interface IComponent 
        interface IDisposable 
    end
public final class Variable extends DtsObject implements IDTSPersist, IDTSName, IDTSPropertiesProvider, IDTSPackagePath, IDTSExecutionPath, IComponent, IDisposable

Variable 유형에서 다음 멤버를 표시합니다.

속성

  이름 설명
공용 속성 CreationName Gets 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 Gets 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 whether the variable contains an expression.
공용 속성 Expression Gets or sets the expression contained in a variable.
공용 속성 ID Gets 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.
공용 속성 Parent Gets the parent container of the Variable instance.
공용 속성 Properties Gets 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 Gets or sets 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 인프라입니다. Gets or sets the site of the variable.
공용 속성 SystemVariable Gets a Boolean that indicates whether 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에서 상속됨)
공용 메서드 GetExecutionPath Returns the execution path of the current Variable 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.
공용 메서드 GetSensitiveValue Returns the sensitive variable value.
공용 메서드 GetType (Object에서 상속됨)
공용 메서드 LoadFromXML This method is not callable by your application code. Loads a package saved as .xml, use the Application.LoadPackage method.
공용 메서드 SaveToXML This method is not callable by your application code. Saves 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) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

참고 항목

참조

Microsoft.SqlServer.Dts.Runtime 네임스페이스