Description プロパティ
データ フロー コンポーネント オブジェクトの説明を取得します。値の設定も可能です。
名前空間: Microsoft.SqlServer.Dts.Runtime
アセンブリ: Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS.dll)
構文
'宣言
Public Property Description As String
Get
Set
'使用
Dim instance As PipelineComponentInfo
Dim value As String
value = instance.Description
instance.Description = value
public string Description { get; set; }
public:
virtual property String^ Description {
String^ get () sealed;
void set (String^ value) sealed;
}
abstract Description : string with get, set
override Description : string with get, set
final function get Description () : String
final function set Description (value : String)
プロパティ値
型: System. . :: . .String
データ フロー コンポーネントの説明を表す String です。
実装
使用例
次のコード例では、PipelineComponentInfos コレクションからパイプライン コンポーネントに関する情報を取得します。コレクションに対する繰り返し処理を実行し、Description など、各 PipelineComponentInfo 内のプロパティの値を出力します。
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
--------------------------------------