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) 成员都是线程安全的。不保证所有实例成员都是线程安全的。