This documentation is archived and is not being maintained.

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)

public ExecuteSQLTask ()
public 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;

The properties and methods of the ExecuteSQLTask are available by using the TaskHost variable, th.


The following code sample creates a new ExecuteSQLTask by using the constructor.

SQLTask myTask = new SQLTask();

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Show: