Sdílet prostřednictvím


IDTSExecuteSQL Interface

Definition

Defines the properties for the Execute SQL task.

public interface class IDTSExecuteSQL
public interface IDTSExecuteSQL
type IDTSExecuteSQL = interface
Public 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.

Applies to