IDTSExecuteSQL Interface
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Defines the properties for the Execute SQL task.
public interface class IDTSExecuteSQLpublic interface IDTSExecuteSQLtype IDTSExecuteSQL = interfacePublic Interface IDTSExecuteSQL- Derived
Properties
| BypassPrepare |
Gets or sets a value 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. |
| Connection |
Gets or sets the name of the connection manager for the Execute SQL task. |
| IsStoredProcedure |
Gets or sets a value that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure. |
| ParameterBindings |
Gets an object that implements IDTSParameterBindings interface. |
| ResultSetBindings |
Gets an object that implements IDTSResultBindings interface. |
| ResultSetType |
Gets or sets the type of result set returned by the SQL statement that the Execute SQL task 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 the type of source that contains the SQL statement that the Execute SQL task runs. |
| TimeOut |
Gets or sets the maximum number of seconds the task can run before timing out. |