ExecuteSQLTask 构造函数

定义

命名空间:

Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask

程序集:

Microsoft.SqlServer.SQLTask.dll

初始化 ExecuteSQLTask 类的新实例。

public:
 ExecuteSQLTask();

public ExecuteSQLTask ();

Public Sub New ()

示例

下面的代码示例使用构造函数创建一个新 ExecuteSQLTask 代码。

SQLTask myTask = new SQLTask();  

Dim myTask As SQLTask =  New SQLTask()  

注解

代码示例演示如何调用任务构造函数。 但是，在大多数情况下，你将创建任务作为包的成员。 有关强制转换任务的详细信息，请参阅中的 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  

可以使用变量th的属性和方法。ExecuteSQLTaskTaskHost