IDTSExecuteSQL Interface

 

This API supports the product 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

NameDescription
System_CAPS_pubpropertyBypassPrepare

This API supports the product infrastructure and is not intended to be used directly from your code. 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).

System_CAPS_pubpropertyCodePage

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the code page to use when translating variable values that are stored as Unicode wide chars to multi-bytes.

System_CAPS_pubpropertyConnection

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the name of the connection manager for the Execute SQL task.

System_CAPS_pubpropertyIsStoredProcedure

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure.

System_CAPS_pubpropertyParameterBindings

This API supports the product infrastructure and is not intended to be used directly from your code. Gets an object that implements IDTSParameterBindings interface.

System_CAPS_pubpropertyResultSetBindings

This API supports the product infrastructure and is not intended to be used directly from your code. Gets an object that implements IDTSResultBindings interface.

System_CAPS_pubpropertyResultSetType

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the type of result set returned by the SQL statement that the Execute SQL task runs.

System_CAPS_pubpropertySqlStatementSource

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the name of the source that contains the SQL statement that the Execute SQL task runs.

System_CAPS_pubpropertySqlStatementSourceType

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the type of source that contains the SQL statement that the Execute SQL task runs.

System_CAPS_pubpropertyTimeOut

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the maximum number of seconds the task can run before timing out.

Return to top
Show: