IDTSExecuteSQL Interface
This API supports the SQL Server 2012 infrastructure and is not intended to be used directly from your code.
Defines the properties for the Execute SQL task.
Namespace: Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
Assembly: Microsoft.SqlServer.SQLTask (in Microsoft.SqlServer.SQLTask.dll)
Syntax
'Declaration
Public Interface IDTSExecuteSQL
'Usage
Dim instance As IDTSExecuteSQL
public interface IDTSExecuteSQL
public interface class IDTSExecuteSQL
type IDTSExecuteSQL = interface end
public interface IDTSExecuteSQL
The IDTSExecuteSQL type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
BypassPrepare | Infrastructure. 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 | Infrastructure. Gets or sets the code page to use when translating variable values that are stored as Unicode wide chars to multi-bytes. |
|
Connection | Infrastructure. Gets or sets the name of the connection manager for the Execute SQL task. |
|
IsStoredProcedure | Infrastructure. Gets or sets a value that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure. |
|
ParameterBindings | Infrastructure. Gets an object that implements IDTSParameterBindings interface. |
|
ResultSetBindings | Infrastructure. Gets an object that implements IDTSResultBindings interface. |
|
ResultSetType | Infrastructure. Gets or sets the type of result set returned by the SQL statement that the Execute SQL task runs. |
|
SqlStatementSource | Infrastructure. Gets or sets the name of the source that contains the SQL statement that the Execute SQL task runs. |
|
SqlStatementSourceType | Infrastructure. Gets or sets the type of source that contains the SQL statement that the Execute SQL task runs. |
|
TimeOut | Infrastructure. Gets or sets the maximum number of seconds the task can run before timing out. |
Top