Класс 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("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
Тип 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. | |
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 Задача служб SSIS «Выполнение SQL».
Безопасность многопоточности
Любые открытые статический (Shared в Visual Basic) элементы этого типа потокобезопасны. Потокобезопасность с элементами экземпляров не гарантируется.