Initializes a new instance of the ExecuteSQLTask class.
Assembly: Microsoft.SqlServer.SQLTask (in Microsoft.SqlServer.SQLTask.dll)
'Declaration Public Sub New 'Usage Dim instance As New ExecuteSQLTask()
new : unit -> ExecuteSQLTask
public function ExecuteSQLTask()
The code sample shows how to call the task constructor. However, in most cases, you will be creating the task as a member of a package. For more information on casting the task, see the remarks in 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
The following code sample creates a new ExecuteSQLTask by using the constructor.
SQLTask myTask = new SQLTask();
Dim myTask As SQLTask = New SQLTask()