This documentation is archived and is not being maintained.

ExecuteSQLTask Properties

  Name Description
ms214873.pubproperty(en-US,SQL.90).gif 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).
ms214873.pubproperty(en-US,SQL.90).gif 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.
ms214873.pubproperty(en-US,SQL.90).gif 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.
ms214873.pubproperty(en-US,SQL.90).gif ExecutionValue Overridden.
Returns the number of rows affected by the SQL statement or statements.
ms214873.pubproperty(en-US,SQL.90).gif IsStoredProcedure
Gets or sets a Boolean that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure.
ms214873.pubproperty(en-US,SQL.90).gif ParameterBindings
Returns an object that implements IDTSParameterBindings.
ms214873.pubproperty(en-US,SQL.90).gif ResultSetBindings
Returns an object that implements IDTSParameterBindings.
ms214873.pubproperty(en-US,SQL.90).gif ResultSetType
Gets or sets a value that indicates the type of result set returned by the SQL statement that the Execute SQL tasks runs.
ms214873.pubproperty(en-US,SQL.90).gif SqlStatementSource
Gets or sets the name of the source that contains the SQL statement that the Execute SQL task runs.
ms214873.pubproperty(en-US,SQL.90).gif SqlStatementSourceType
Gets or sets a value that indicates the type of source that contains the SQL statement that the Execute SQL task runs.
ms214873.pubproperty(en-US,SQL.90).gif TimeOut
Gets or sets an integer that indicates the maximum number of seconds the task can run before timing out.
ms214873.pubproperty(en-US,SQL.90).gif Version 
Returns the version of the task. This property is read-only.
(inherited from Task )
ms214873.pubproperty(en-US,SQL.90).gif WaitForMe 
Returns a Boolean that indicates whether the parent container should wait for completion of this task. This property is read-only.
(inherited from Task )
Show: