ExecuteSQLTask Properties
Assembly: Microsoft.SqlServer.SQLTask (in Microsoft.SqlServer.SQLTask.dll)
| 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.) |
