ExecuteSQLTask Properties

 

Namespace:   Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
Assembly:  Microsoft.SqlServer.SQLTask (in Microsoft.SqlServer.SQLTask.dll)

NameDescription
System_CAPS_pubpropertyBypassPrepare

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).

System_CAPS_pubpropertyCodePage

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.

System_CAPS_pubpropertyConnection

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.

System_CAPS_pubpropertyExecutionValue

Returns the number of rows affected by the SQL statement or statements.(Overrides Task::ExecutionValue.)

System_CAPS_pubpropertyIsStoredProcedure

Gets or sets a Boolean that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure.

System_CAPS_pubpropertyParameterBindings

Returns an object that implements IDTSParameterBindings.

System_CAPS_pubpropertyResultSetBindings

Returns an object that implements IDTSParameterBindings.

System_CAPS_pubpropertyResultSetType

Gets or sets a value that indicates the type of result set returned by the SQL statement that the Execute SQL tasks runs.

System_CAPS_pubpropertySqlStatementSource

Gets or sets the name of the source that contains the SQL statement that the Execute SQL task runs.

System_CAPS_pubpropertySqlStatementSourceType

Gets or sets a value that indicates the type of source that contains the SQL statement that the Execute SQL task runs.

System_CAPS_pubpropertyTargetServerVersion

(Inherited from Task.)

System_CAPS_pubpropertyTimeOut

Gets or sets an integer that indicates the maximum number of seconds the task can run before timing out.

System_CAPS_pubpropertyTypeConversionMode

Gets or sets the conversion mode used by the Execute SQL Task.

System_CAPS_pubpropertyVersion

*** Member deprecated; see Remarks. ***   Returns the version of the task. This property is read-only.(Inherited from Task.)

Return to top
Show: