DtsContainer.Disable プロパティ
DtsContainer オブジェクトが無効かどうかを示す Boolean です。
名前空間: Microsoft.SqlServer.Dts.Runtime
アセンブリ: Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS.dll)
構文
'宣言
Public Property Disable As Boolean
Get
Set
'使用
Dim instance As DtsContainer
Dim value As Boolean
value = instance.Disable
instance.Disable = value
public bool Disable { get; set; }
public:
property bool Disable {
bool get ();
void set (bool value);
}
member Disable : bool with get, set
function get Disable () : boolean
function set Disable (value : boolean)
プロパティ値
型: System.Boolean
オブジェクトが無効かどうかを示す Boolean です。true の場合、DtsContainer は無効であり、オブジェクトは実行されません。
説明
既定値は false です。
使用例
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: MSDTS.Package.1
DebugMode: False
DelayValidation: True
Description:
Disable: False
Description after modification: This is the Execute Process Package Sample