ExecuteSQLTask Konstruktor

Definisi

Ruang nama:

Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask

Rakitan:

Microsoft.SqlServer.SQLTask.dll

Menginisialisasi instans baru kelas ExecuteSQLTask.

public:
 ExecuteSQLTask();

public ExecuteSQLTask ();

Public Sub New ()

Contoh

Sampel kode berikut membuat yang baru ExecuteSQLTask dengan menggunakan konstruktor.

SQLTask myTask = new SQLTask();  

Dim myTask As SQLTask =  New SQLTask()  

Keterangan

Sampel kode menunjukkan cara memanggil konstruktor tugas. Namun, dalam kebanyakan kasus, Anda akan membuat tugas sebagai anggota paket. Untuk informasi selengkapnya tentang transmisi tugas, lihat keterangan di Add.

Package pkg = new Package();  
Executable exec1 = pkg.Executables.Add("STOCK:SQLTask");  
TaskHost th = exec1 as TaskHost;  
// You can cast the InnerObject of the TaskHost  
// to the specific class.  
// For the code samples, the task properties are accessed by using  
// the properties collection of the TaskHost.  
// SQLTask myTask = th.InnerObject as SQLTask;  

Dim pkg As Package =  New Package()   
Dim exec1 As Executable =  pkg.Executables.Add("STOCK:SQLTask")   
Dim th As TaskHost =  exec1 as TaskHost   
' You can cast the InnerObject of the TaskHost  
' to the specific class.  
' For the code samples, the task properties are accessed by using  
' the Properties collection of the TaskHost.  
' Dim myTask As SQLTask =  th.InnerObject as SQLTask  

Properti dan metode ExecuteSQLTask tersedia dengan menggunakan TaskHost variabel , th.