Executable Konstruktor

Definisi

Ruang nama:

Microsoft.SqlServer.Dts.Runtime

Rakitan:

Microsoft.SqlServer.ManagedDTS.dll

Menginisialisasi instans baru kelas Executable.

protected:
 Executable();

protected Executable ();

Protected Sub New ()

Contoh

Kelas Paket adalah anak dari kelas Executables melalui beberapa tingkat pewarisan. Contoh kode berikut menunjukkan cara menggunakan Executable kelas dengan paket untuk menambahkan tugas Sisipkan Massal yang dapat dieksekusi ke Executables kumpulan paket.

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);  
                }  
        }  
}  

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)  
                End Sub  
        End Class  
End Namespace  

Contoh Output:

The first package contains 1 executables