Поделиться через


PipelineComponentInfo.Description Property

Gets or sets the description of the data flow component object.

Пространство имен: Microsoft.SqlServer.Dts.Runtime
Сборка: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Синтаксис

'Декларация
Public Property Description As String
public string Description { get; set; }
public:
virtual property String^ Description {
    String^ get () sealed;
    void set (String^ value) sealed;
}
/** @property */
public final String get_Description ()

/** @property */
public final void set_Description (String value)
public final function get Description () : String

public final function set Description (value : String)

Значение свойства

A String that contains the description of the data flow component.

Пример

The following code sample retrieves the information about the pipeline components from the PipelineComponentInfos collection. The sample iterates through the collection, and then prints the values for the properties in each PipelineComponentInfo, including the Description.

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

Sample Output:

ComponentType: Transform

CreationName: DTSTransform.Merge.1

Description: Merge Transformation

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

FileNameVersionString: 2000.90.1049.0

IconFile: C:\Program Files\Microsoft SQL Server\90\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=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91

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

ComponentType: Transform

CreationName: DTSTransform.MergeJoin.1

Description: Merge Join Transformation

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

FileNameVersionString: 2000.90.1049.0

IconFile: C:\Program Files\Microsoft SQL Server\90\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=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91

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

Синхронизация потоков

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Платформы

Платформы разработки

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

Целевые платформы

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

См. также

Справочник

PipelineComponentInfo Class
PipelineComponentInfo Members
Microsoft.SqlServer.Dts.Runtime Namespace