ExecuteSQLTask Constructor

Article
12/15/2008

Initializes a new instance of the ExecuteSQLTask class.

Espace de noms: Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
Assembly: Microsoft.SqlServer.SQLTask (in microsoft.sqlserver.sqltask.dll)

Syntaxe

'Déclaration
Public Sub New

public ExecuteSQLTask ()

public:
ExecuteSQLTask ()

public ExecuteSQLTask ()

public function ExecuteSQLTask ()

Notes

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.

Exemple

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

SQLTask myTask = new SQLTask();

Dim myTask As SQLTask =  New SQLTask()

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

ExecuteSQLTask Class
ExecuteSQLTask Members
Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask Namespace

Partager via