Executables.Item プロパティ
Executable オブジェクトをコレクションから取得します。
名前空間: Microsoft.SqlServer.Dts.Runtime
アセンブリ: Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS.dll)
構文
'宣言
Public ReadOnly Default Property Item ( _
index As Object _
) As Executable
Get
'使用
Dim instance As Executables
Dim index As Object
Dim value As Executable
value = instance(index)
public Executable this[
Object index
] { get; }
public:
property Executable^ default[Object^ index] {
Executable^ get (Object^ index);
}
member Item : Executable
JScript はインデックス化されたプロパティの使用をサポートしていますが、新規の宣言はサポートしていません。
パラメーター
- index
型: System.Object
返す Executable オブジェクトのインデックスです。
プロパティ値
型: Microsoft.SqlServer.Dts.Runtime.Executable
コレクションからの Executable オブジェクトです。
説明
Contains メソッドの呼び出しが true を返す場合、Executables[index] 構文を使用することにより、コレクション内の指定した要素にアクセスできます。 Contains が false を返す場合、このプロパティは例外をスローします。 C# の場合、このプロパティは Executables クラスのインデクサーとなります。
使用例
次の例は、Remove で使用したサンプルを変更したものです。 項目構文を使用して実行可能オブジェクトを削除します。
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Dts.Tasks.BulkInsertTask;
namespace Executables_API
{
class Program
{
static void Main(string[] args)
{
Executable exec = pkg.Executables.Add("STOCK:BulkInsertTask");
TaskHost myTask = exec as TaskHost;
BulkInsertTask myBI = myTask.InnerObject as BulkInsertTask;
myBI.DebugMode = false;
myBI.CheckConstraints = false;
myBI.KeepIdentity = true;
// Obtain the collection.
Executables pgkExecs = pkg.Executables;
// Show the number of executables in the collection.
Console.WriteLine("The first package contains {0} executables", pgkExecs.Count);
// It is a requirement to Remove the task from the
// existing package before adding it to the new package.
// Remove the exectuable using the Executables[x] item syntax.
DtsContainer c = (DtsContainer)pkg.Executables[0];
pkg.Executables.Remove(c);
// Show the number of executables in the collection afterwards.
Console.WriteLine("The first package now contains {0} executables", pgkExecs.Count);
Package pkg2 = new Package();
Executables p2Execs = pkg2.Executables;
// Show the number of executables in the second collection.
Console.WriteLine("The second package initially contains {0} executables", p2Execs.Count);
// Join the task from pkg to pkg2.
pkg2.Executables.Join(myTask);
// Show the number of executables in the second collection after Join.
Console.WriteLine("The second package now contains {0} executables", p2Execs.Count);
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Imports Microsoft.SqlServer.Dts.Tasks.BulkInsertTask
Namespace Executables_API
Class Program
Shared Sub Main(ByVal args() As String)
Dim exec As Executable = pkg.Executables.Add("STOCK:BulkInsertTask")
Dim myTask As TaskHost = exec as TaskHost
Dim myBI As BulkInsertTask = myTask.InnerObject as BulkInsertTask
myBI.DebugMode = False
myBI.CheckConstraints = False
myBI.KeepIdentity = True
' Obtain the collection.
Dim pgkExecs As Executables = pkg.Executables
' Show the number of executables in the collection.
Console.WriteLine("The first package contains {0} executables", pgkExecs.Count)
' It is a requirement to Remove the task from the
' existing package before adding it to the new package.
' Remove the exectuable using the Executables[x] item syntax.
Dim c As DtsContainer = CType(pkg.Executables(0), DtsContainer)
pkg.Executables.Remove(c)
' Show the number of executables in the collection afterwards.
Console.WriteLine("The first package now contains {0} executables", pgkExecs.Count)
Dim pkg2 As Package = New Package()
Dim p2Execs As Executables = pkg2.Executables
' Show the number of executables in the second collection.
Console.WriteLine("The second package initially contains {0} executables", p2Execs.Count)
' Join the task from pkg to pkg2.
pkg2.Executables.Join(myTask)
' Show the number of executables in the second collection after Join.
Console.WriteLine("The second package now contains {0} executables", p2Execs.Count)
End Sub
End Class
End Namespace
サンプル出力:
The first package contains 1 executables
The first package now contains 0 executables
The second package initially contains 0 executables
The second package now contains 1 executables