Aracılığıyla paylaş

  • Makale

Executables.Join Yöntemi

Bir var olan bir kapsayıcı veya görev nesnesi ekler Executables koleksiyon.

Ad Alanı:  Microsoft.SqlServer.Dts.Runtime
Derleme:  Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS içinde.dll)

Sözdizimi

'Bildirim
Public Sub Join ( _
    executable As Executable _
)
'Kullanım
Dim instance As Executables
Dim executable As Executable

instance.Join(executable)

public void Join(
    Executable executable
)

public:
void Join(
    Executable^ executable
)

member Join : 
        executable:Executable -> unit 

public function Join(
    executable : Executable
)

Parametreler

Açıklamalar

Use Join taşıdığınızda bir kapsayıcı veya görev bir kap (kaynak) başka bir (hedef).Kaynak kapsayıcı kullanarak nesneyi kaldırmanız gerekir Remove önce edinilecek Join hedef.

Örnekler

Aşağıdaki örnek toplu Ekle görev oluşturur ve bazı özelliklerini ayarlar.Ekle toplu görev sonra ilk paket kaldırıldı ve ikinci pakete eklenir.Özelliklerini küme ilk paketinin bir parçası olup değişmeden kalır.

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

Örnek Çıktı:

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