Export (0) Print
Expand All

ExecuteSQLTask Properties

The ExecuteSQLTask type exposes the following members.

  NameDescription
Public property 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).
Public property 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.
Public property 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.
Public property ExecutionValue Returns the number of rows affected by the SQL statement or statements. (Overrides Task.ExecutionValue.)
Public property IsStoredProcedure Gets or sets a Boolean that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure.
Public property ParameterBindings Returns an object that implements IDTSParameterBindings.
Public property ResultSetBindings Returns an object that implements IDTSParameterBindings.
Public property ResultSetType Gets or sets a value that indicates the type of result set returned by the SQL statement that the Execute SQL tasks runs.
Public property SqlStatementSource Gets or sets the name of the source that contains the SQL statement that the Execute SQL task runs.
Public property SqlStatementSourceType Gets or sets a value that indicates the type of source that contains the SQL statement that the Execute SQL task runs.
Public property TimeOut Gets or sets an integer that indicates the maximum number of seconds the task can run before timing out.
Public property Version *** Member deprecated; see Remarks. ***   Returns the version of the task. This property is read-only. (Inherited from Task.)
Top

Community Additions

ADD
Show:
© 2014 Microsoft