ExecuteSQLTask Constructor
Initializes a new instance of the ExecuteSQLTask class.
Namespace: Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
Assembly: Microsoft.SqlServer.SQLTask (in Microsoft.SqlServer.SQLTask.dll)
Syntax
'Declaration
Public Sub New
'Usage
Dim instance As New ExecuteSQLTask()
public ExecuteSQLTask()
public:
ExecuteSQLTask()
new : unit -> ExecuteSQLTask
public function ExecuteSQLTask()
Remarks
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 properties and methods of the ExecuteSQLTask are available by using the TaskHost variable, th.
Examples
The following code sample creates a new ExecuteSQLTask by using the constructor.
SQLTask myTask = new SQLTask();
Dim myTask As SQLTask = New SQLTask()