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.

命名空間：  Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
組件：  Microsoft.SqlServer.SQLTask (在 Microsoft.SqlServer.SQLTask.dll 中)

語法

'宣告
<GuidAttribute("3E0AAEAA-F8DC-370D-9206-0FC456CE748F")> _
Public Class ExecuteSQLTask _
    Inherits Task _
    Implements IDTSExecuteSQL, IDTSComponentPersist
'用途
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

備註

For more information about the features of this task, see 執行 SQL 工作.

範例

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.

繼承階層

System. . :: . .Object
  Microsoft.SqlServer.Dts.Runtime. . :: . .DtsObject
    Microsoft.SqlServer.Dts.Runtime. . :: . .Task
      Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask..::..ExecuteSQLTask

執行緒安全性

這個類型的任何公用static (在 Visual Basic 中為 Shared) 成員都是安全執行緒。不保證任何執行個體成員都可以是安全執行緒。

請參閱

參考

ExecuteSQLTask 成員

Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask 命名空間