Executables.Join(Executable) Metodo

Definizione

Spazio dei nomi:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Aggiunge un oggetto contenitore o attività esistente alla raccolta Executables.

public:
 void Join(Microsoft::SqlServer::Dts::Runtime::Executable ^ executable);

public void Join (Microsoft.SqlServer.Dts.Runtime.Executable executable);

member this.Join : Microsoft.SqlServer.Dts.Runtime.Executable -> unit

Public Sub Join (executable As Executable)

Parametri

executable

Executable

Nome dell'oggetto TaskHost esistente per il contenitore o l'attività.

Esempio

Nell'esempio seguente viene creata un'attività Inserimento bulk e vengono impostate alcune proprietà. L'attività Inserimento bulk viene quindi rimossa dal primo pacchetto e aggiunta al secondo pacchetto. Le proprietà impostate mentre faceva parte del primo pacchetto rimangono invariate.

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)  
        {  
                      // Create the package and add the BulkInsertTask.  
                      Package pkg = new Package();  
                      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.  
                      pkg.Executables.Remove(0);  
                      // 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)  
                      ' Create the package and add the BulkInsertTask.  
                      Dim pkg As Package =  New Package()   
                      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.  
                      pkg.Executables.Remove(0)  
                      ' 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  

Esempio di output

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

Commenti

Usare Join quando si sposta un contenitore o un'attività da un contenitore (origine) a un altro (destinazione). È necessario rimuovere l'oggetto dal contenitore di origine usando Remove prima di chiamare Join sulla destinazione.