Description プロパティ
DtsContainer オブジェクトの説明を取得します。値の設定も可能です。
名前空間: Microsoft.SqlServer.Dts.Runtime
アセンブリ: Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS.dll)
構文
'宣言
Public Property Description As String
Get
Set
'使用
Dim instance As DtsContainer
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 です。
実装
使用例
Package クラスは、EventsProvider の継承によって DtsContainer を実装します。次のコード例では、パッケージを作成した後、DtsContainer から継承した値を表示および設定します。
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace Microsoft.SqlServer.SSIS.Samples
{
class Program
{
static void Main(string[] args)
{
// The package is the ExecuteProcess package sample
// that is installed with the SSIS samples.
string pkg = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";
Application app = new Application();
Package p1 = app.LoadPackage(pkg, null);
// Show the properties inherited from DtsContainer.
Console.WriteLine("CreationName: {0}", p1.CreationName);
Console.WriteLine("DebugMode: {0}", p1.DebugMode);
Console.WriteLine("DelayValidation: {0}", p1.DelayValidation);
Console.WriteLine("Description: {0}", p1.Description);
Console.WriteLine("Disable: {0}", p1.Disable);
// Description is not set for this sample, so set it.
p1.Description = "This is the Execute Process Package Sample";
Console.WriteLine("Description after modification: {0}", p1.Description);
Console.WriteLine();
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace Microsoft.SqlServer.SSIS.Samples
Class Program
Shared Sub Main(ByVal args() As String)
' The package is the ExecuteProcess package sample
' that is installed with the SSIS samples.
Dim pkg As String = "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx"
Dim app As Application = New Application()
Dim p1 As Package = app.LoadPackage(pkg,Nothing)
' Show the properties inherited from DtsContainer.
Console.WriteLine("CreationName: {0}", p1.CreationName)
Console.WriteLine("DebugMode: {0}", p1.DebugMode)
Console.WriteLine("DelayValidation: {0}", p1.DelayValidation)
Console.WriteLine("Description: {0}", p1.Description)
Console.WriteLine("Disable: {0}", p1.Disable)
' Description is not set for this sample, so set it.
p1.Description = "This is the Execute Process Package Sample"
Console.WriteLine("Description after modification: {0}", p1.Description)
Console.WriteLine()
End Sub
End Class
End Namespace
サンプルの出力 :
CreationName: SSIS.Package.2
DebugMode: False
DelayValidation: True
Description:
Disable: False
Description after modification: This is the Execute Process Package Sample