Executables.Item[Object] Propriedade

Definição

Namespace:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Obtém um objeto Executable da coleção.

public:
 property Microsoft::SqlServer::Dts::Runtime::Executable ^ default[System::Object ^] { Microsoft::SqlServer::Dts::Runtime::Executable ^ get(System::Object ^ index); };

public Microsoft.SqlServer.Dts.Runtime.Executable this[object index] { get; }

member this.Item(obj) : Microsoft.SqlServer.Dts.Runtime.Executable

Default Public ReadOnly Property Item(index As Object) As Executable

Parâmetros

index

Object

O índice do objeto Executable a ser retornado.

Valor da propriedade

Executable

Um objeto Executable da coleção.

Exemplos

O exemplo a seguir é uma modificação do exemplo encontrado em Remover. Ele remove o executável usando a sintaxe do item.

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  

Saída de exemplo:

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

Comentários

Se a chamada para o Contains método retornar true, você poderá acessar o elemento especificado na coleção usando a sintaxe Executables[index]. Se a Contains propriedade retornar false, essa propriedade gerará uma exceção. Em C#, essa propriedade é o indexador da classe Executables.