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.
ExecuteSQLTask 型別公開下列成員。
方法
| 名稱 | 描述 | |
|---|---|---|
.gif "公用方法") |
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)。) |
.gif "受保護的方法") |
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)。) |
頂端
屬性
| 名稱 | 描述 | |
|---|---|---|
.gif "公用屬性") |
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. |
|
Version | *** Member deprecated; see Remarks. *** Returns the version of the task. This property is read-only. (繼承自 Task。) |
頂端