Classe ExecuteSQLTask
Contains the members used to configure and run an Execute SQL task. The Execute SQL task is used to execute SQL commands against a relational database table or view.
Namespace: Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
Assembly: Microsoft.SqlServer.SQLTask (em Microsoft.SqlServer.SQLTask.dll)
Sintaxe
'Declaração
<GuidAttribute("3E0AAEAA-F8DC-370D-9206-0FC456CE748F")> _
Public Class ExecuteSQLTask _
Inherits Task _
Implements IDTSExecuteSQL, IDTSComponentPersist
'Uso
Dim instance As ExecuteSQLTask
[GuidAttribute("3E0AAEAA-F8DC-370D-9206-0FC456CE748F")]
public class ExecuteSQLTask : Task,
IDTSExecuteSQL, IDTSComponentPersist
[GuidAttribute(L"3E0AAEAA-F8DC-370D-9206-0FC456CE748F")]
public ref class ExecuteSQLTask : public Task,
IDTSExecuteSQL, IDTSComponentPersist
[<GuidAttribute("3E0AAEAA-F8DC-370D-9206-0FC456CE748F")>]
type ExecuteSQLTask =
class
inherit Task
interface IDTSExecuteSQL
interface IDTSComponentPersist
end
public class ExecuteSQLTask extends Task implements IDTSExecuteSQL, IDTSComponentPersist
Exemplos
For a community sample that demonstrates how to add and configure an Execute SQL Task, see the blog entry, Creating packages in code -- Execute SQL Task, on sqlis.com.
Hierarquia de herança
System. . :: . .Object
Microsoft.SqlServer.Dts.Runtime. . :: . .DtsObject
Microsoft.SqlServer.Dts.Runtime. . :: . .Task
Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask..::..ExecuteSQLTask
Segurança de thread
Quaisquer membros static (Shared no Visual Basic) públicos deste tipo são thread-safe. Não há garantia de que qualquer membro de instância seja thread-safe.
Consulte também