ExecuteSQLTask Class
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.
Assembly: Microsoft.SqlServer.SQLTask (in Microsoft.SqlServer.SQLTask.dll)
Microsoft.SqlServer.Dts.Runtime::DtsObject
Microsoft.SqlServer.Dts.Runtime::Task
Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask::ExecuteSQLTask
| Name | Description | |
|---|---|---|
![]() | ExecuteSQLTask() | Initializes a new instance of the ExecuteSQLTask class. |
| Name | Description | |
|---|---|---|
![]() | 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.(Overrides 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. |
![]() | TargetServerVersion | (Inherited from Task.) |
![]() | 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.(Inherited from Task.) |
For more information about the features of this task, see Execute SQL Task.
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.


