DTSPropertyKind 열거형

정의

네임스페이스:

Microsoft.SqlServer.Dts.Runtime

어셈블리:

Microsoft.SqlServer.ManagedDTS.dll

속성 유형에 대해 설명하는 값을 포함합니다.

public enum class DTSPropertyKind

public enum DTSPropertyKind

type DTSPropertyKind = 

Public Enum DTSPropertyKind

상속

Enum

DTSPropertyKind

필드

Connection	3	속성이 연결입니다.
Other	0	사용 가능한 열거형에서 속성에 대해 설명하지 않습니다.
Sensitive	4	속성이 대/소문자 구분입니다.
VariableReadOnly	1	속성이 읽기 전용 변수입니다.
VariableReadWrite	2	속성이 읽기/쓰기 변수입니다.

예제

다음 코드 샘플에서는 특정 속성에 대한 속성 종류를 검색하는 방법을 보여 있습니다.

static void Main(string[] args)  
    {  
        // The variable pkg points to the location  
        // of the ExecuteProcess package sample   
        // that is installed with the SSIS samples.  
        string packageFile = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";  

        Application application = new Application();  
        Package package = application.LoadPackage(packageFile, null);  

        // Retrieve the information from the Properties collection.  
        // Each item in the collection represents a property on the  
        // object. This example reviews the properties of the   
        // Package object.  

        DtsProperties properties = package.Properties;  

        String propertyName;  
        DTSPropertyKind propertyKind;  
        String packagePath;  
        TypeCode propertyType;  

        foreach (DtsProperty property in properties)  
        {  
            propertyType = property.Type;  
            propertyName = property.Name;  
            propertyKind = property.PropertyKind;  
            packagePath = property.GetPackagePath(package);  
            Console.WriteLine("Property Type: {0}, Property Name: {1}, Property Kind: {2}, Package Path: {3} ",   
            propertyType, propertyName, propertyKind, packagePath);  
        }  
    }  

Shared  Sub Main(ByVal args() As String)  
        ' The variable pkg points to the location  
        ' of the ExecuteProcess package sample   
        ' that is installed with the SSIS samples.  
        Dim packageFile As String =  "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx"   

        Dim application As Application =  New Application()   
        Dim package As Package =  application.LoadPackage(packageFile,Nothing)   

        ' Retrieve the information from the Properties collection.  
        ' Each item in the collection represents a property on the  
        ' object. This example reviews the properties of the   
        ' Package object.  

        Dim properties As DtsProperties = package.Properties   

        Dim propertyName As String  
        Dim propertyKind As DTSPropertyKind  
        Dim packagePath As String  
        Dim propertyType As TypeCode  

        Dim property As DtsProperty  
        For Each property In properties  
            propertyType = property.Type  
            propertyName = property.Name  
            propertyKind = property.PropertyKind  
            packagePath = property.GetPackagePath(package)  
            Console.WriteLine("Property Type: {0}, Property Name: {1}, Property Kind: {2}, Package Path: {3} ",   
            propertyType, propertyName, propertyKind, packagePath)  
        Next  
End Sub