PipelineComponentInfo.ComponentType 속성

정의

네임스페이스:

Microsoft.SqlServer.Dts.Runtime

어셈블리:

Microsoft.SqlServer.ManagedDTS.dll

구성 요소를 원본, 대상 또는 변환으로 식별하는 DTSPipelineComponentType 열거자를 반환합니다. 이 속성은 읽기 전용입니다.

public:
 property Microsoft::SqlServer::Dts::Runtime::DTSPipelineComponentType ComponentType { Microsoft::SqlServer::Dts::Runtime::DTSPipelineComponentType get(); };

public Microsoft.SqlServer.Dts.Runtime.DTSPipelineComponentType ComponentType { get; }

member this.ComponentType : Microsoft.SqlServer.Dts.Runtime.DTSPipelineComponentType

Public ReadOnly Property ComponentType As DTSPipelineComponentType

속성 값

DTSPipelineComponentType

DTSPipelineComponentType 열거자의 값입니다.

예제

다음 코드 샘플은 컬렉션에서 PipelineComponentInfos 파이프라인 구성 요소에 대한 정보를 검색합니다. 이 샘플은 컬렉션을 반복한 다음 각 속성PipelineComponentInfoComponentType에 대한 값을 인쇄합니다.

using System;  
using System.Collections.Generic;  
using System.Text;  
using Microsoft.SqlServer.Dts.Runtime;  

namespace TaskInfos_Item  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            Application app = new Application();  
            PipelineComponentInfos pInfos = app.PipelineComponentInfos;  
            // Iterate through the collection,   
            // printing values for the properties.  
            foreach (PipelineComponentInfo pInfo in pInfos)  
            {  
                Console.WriteLine("ComponentType:      {0}", pInfo.ComponentType);  
                Console.WriteLine("CreationName:       {0}", pInfo.CreationName);  
                Console.WriteLine("Description:        {0}", pInfo.Description);  
                Console.WriteLine("FileName:           {0}", pInfo.FileName);  
                //Console.WriteLine("FileNameVersionString:   {0}", pInfo.FileNameVersionString);  
                Console.WriteLine("IconFile:           {0}", pInfo.IconFile);  
                Console.WriteLine("IconResource:       {0}", pInfo.IconResource);  
                Console.WriteLine("ID:                 {0}", pInfo.ID);  
                Console.WriteLine("Name:               {0}", pInfo.Name);  
                Console.WriteLine("NoEditor:           {0}", pInfo.NoEditor);  
                Console.WriteLine("ShapeProgID:        {0}", pInfo.ShapeProgID);  
                Console.WriteLine("UITypeName:         {0}", pInfo.UITypeName);  
                Console.WriteLine("--------------------------------------");  
            }  
        }  
    }  
}  

Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  

Namespace TaskInfos_Item  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
            Dim app As Application =  New Application()   
            Dim pInfos As PipelineComponentInfos =  app.PipelineComponentInfos   
            ' Iterate through the collection,   
            ' printing values for the properties.  
            Dim pInfo As PipelineComponentInfo  
            For Each pInfo In pInfos  
                Console.WriteLine("ComponentType:      {0}", pInfo.ComponentType)  
                Console.WriteLine("CreationName:       {0}", pInfo.CreationName)  
                Console.WriteLine("Description:        {0}", pInfo.Description)  
                Console.WriteLine("FileName:           {0}", pInfo.FileName)  
                'Console.WriteLine("FileNameVersionString:   {0}", pInfo.FileNameVersionString)  
                Console.WriteLine("IconFile:           {0}", pInfo.IconFile)  
                Console.WriteLine("IconResource:       {0}", pInfo.IconResource)  
                Console.WriteLine("ID:                 {0}", pInfo.ID)  
                Console.WriteLine("Name:               {0}", pInfo.Name)  
                Console.WriteLine("NoEditor:           {0}", pInfo.NoEditor)  
                Console.WriteLine("ShapeProgID:        {0}", pInfo.ShapeProgID)  
                Console.WriteLine("UITypeName:         {0}", pInfo.UITypeName)  
                Console.WriteLine("--------------------------------------")  
            Next  
        End Sub  
    End Class  

샘플 출력:

ComponentType: Transform

CreationName: DTSTransform.Merge.1

Description: Merge Transformation

FileName: C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents\TxMerge.dll

IconFile: C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents\TxMerge.dll

IconResource: -201

ID: {08AE886A-4124-499C-B332-16E3299D225A}

Name: Merge

NoEditor: False

ShapeProgID:

UITypeName: Microsoft.DataTransformationServices.DataFlowUI.MergeUI, Microsoft.DatatransformationServices.DataFlowUI, Version=10.0.000.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91

--------------------------------------

ComponentType: Transform

CreationName: DTSTransform.MergeJoin.1

Description: Merge Join Transformation

FileName: C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents\TxMergeJoin.dll

IconFile: C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents\TxMergeJoin.dll

IconResource: -201

ID: {0D598A60-0A32-4B1B-A72C-5030B64E3A20}

Name: Merge Join

NoEditor: False

ShapeProgID:

UITypeName: Microsoft.DataTransformationServices.Design.DtsMergeJoinComponentUI, Microsoft.DatatransformationServices.DataFlowUI, Version=10.0.000.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91

--------------------------------------

설명

이 속성은 구성 요소를 원본, 변환 또는 대상 구성 요소로 식별합니다. 디자이너는 Data Flow 항목 도구 상자에서 구성 요소를 그룹화할 때 이 특성을 사용하고 항목을 위에서 아래로 구성하고, 원본 구성 요소를 먼저 정렬하고, 변환 구성 요소를 두 번째로, 대상 구성 요소를 마지막으로 정렬합니다.