Export (0) Print
Expand All

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)

public interface IDTSExecuteSQL

The IDTSExecuteSQL type exposes the following members.

  NameDescription
Public propertyBypassPrepareInfrastructure. 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).
Public propertyCodePageInfrastructure. Gets or sets the code page to use when translating variable values that are stored as Unicode wide chars to multi-bytes.
Public propertyConnectionInfrastructure. Gets or sets the name of the connection manager for the Execute SQL task.
Public propertyIsStoredProcedureInfrastructure. Gets or sets a value that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure.
Public propertyParameterBindingsInfrastructure. Gets an object that implements IDTSParameterBindings interface.
Public propertyResultSetBindingsInfrastructure. Gets an object that implements IDTSResultBindings interface.
Public propertyResultSetTypeInfrastructure. Gets or sets the type of result set returned by the SQL statement that the Execute SQL task runs.
Public propertySqlStatementSourceInfrastructure. Gets or sets the name of the source that contains the SQL statement that the Execute SQL task runs.
Public propertySqlStatementSourceTypeInfrastructure. Gets or sets the type of source that contains the SQL statement that the Execute SQL task runs.
Public propertyTimeOutInfrastructure. Gets or sets the maximum number of seconds the task can run before timing out.
Top

Community Additions

ADD
Show:
© 2014 Microsoft