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.

繼承階層

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

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

語法

'宣告
<GuidAttribute("C876C481-2EA3-40E1-9D75-5F73D0BED1D4")> _
Public Class ExecuteSQLTask _
    Inherits Task _
    Implements IDTSExecuteSQL, IDTSComponentPersist
'用途
Dim instance As ExecuteSQLTask

[GuidAttribute("C876C481-2EA3-40E1-9D75-5F73D0BED1D4")]
public class ExecuteSQLTask : Task, 
    IDTSExecuteSQL, IDTSComponentPersist

[GuidAttribute(L"C876C481-2EA3-40E1-9D75-5F73D0BED1D4")]
public ref class ExecuteSQLTask : public Task, 
    IDTSExecuteSQL, IDTSComponentPersist

[<GuidAttribute("C876C481-2EA3-40E1-9D75-5F73D0BED1D4")>]
type ExecuteSQLTask =  
    class 
        inherit Task 
        interface IDTSExecuteSQL 
        interface IDTSComponentPersist 
    end

public class ExecuteSQLTask extends Task implements IDTSExecuteSQL, IDTSComponentPersist

ExecuteSQLTask 型別公開下列成員。

建構函式

	名稱	說明
	ExecuteSQLTask	Initializes a new instance of the ExecuteSQLTask class.

上層

屬性

	名稱	說明
	BypassPrepare	Gets or sets a Boolean that indicates whether the Execute SQL task skips preparation of the statement when sending the SQL statement to the relational database management system (RDBMS).
	CodePage	Gets or sets the code page to use when translating variable values that are stored as Unicode wide chars to multi-bytes. Translation occurs either when storing values to or extracting values from databases.
	Connection	Gets or sets the name of the connection manager that connects to the relational database management system (RDBMS) where the Execute SQL task is run.
	ExecutionValue	Returns the number of rows affected by the SQL statement or statements. (覆寫 Task.ExecutionValue。)
	IsStoredProcedure	Gets or sets a Boolean that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure.
	ParameterBindings	Returns an object that implements IDTSParameterBindings.
	ResultSetBindings	Returns an object that implements IDTSParameterBindings.
	ResultSetType	Gets or sets a value that indicates the type of result set returned by the SQL statement that the Execute SQL tasks runs.
	SqlStatementSource	Gets or sets the name of the source that contains the SQL statement that the Execute SQL task runs.
	SqlStatementSourceType	Gets or sets a value that indicates the type of source that contains the SQL statement that the Execute SQL task runs.
	TimeOut	Gets or sets an integer that indicates the maximum number of seconds the task can run before timing out.
	TypeConversionMode	Gets or sets the conversion mode used by the Execute SQL Task.
	Version	*** Member deprecated; see Remarks. ***    Returns the version of the task. This property is read-only. (繼承自 Task。)

上層

方法

	名稱	說明
	CanUpdate	*** Member deprecated; see Remarks. ***    A Boolean that indicates whether the new package XML can update the old package XML. (繼承自 Task。)
	Equals	Determines whether two object instances are equal. (繼承自 DtsObject。)
	Execute	Runs the task. (覆寫 Task.Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object)。)
	Finalize	(繼承自 Object。)
	GetConnectionID	Gets a String containing the ID of the connection. (繼承自 Task。)
	GetConnectionName	Gets a String containing the name of the connection. (繼承自 Task。)
	GetHashCode	Returns the hash code for this instance. (繼承自 DtsObject。)
	GetType	(繼承自 Object。)
	InitializeTask	Initializes the properties associated with the Execute SQL task. This method is called by the runtime and is not used in code. (覆寫 Task.InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker)。)
	LoadFromXML	This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
	MemberwiseClone	(繼承自 Object。)
	SaveToXML	This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
	ToString	(繼承自 Object。)
	Update	*** Member deprecated; see Remarks. ***    This method updates the old package XML with the new package XML if CanUpdate is set to true. (繼承自 Task。)
	Validate	Verifies that the task is properly configured. (覆寫 Task.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging)。)

上層

備註

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

執行緒安全性

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

請參閱

參考

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