共用方式為


IDTSExecuteSQL 介面

此 API 支援 SQL Server 2012 基礎結構,但無法直接從您的程式碼使用。

Defines the properties for the Execute SQL task.

命名空間:  Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
組件:  Microsoft.SqlServer.SQLTask (在 Microsoft.SqlServer.SQLTask.dll 中)

語法

'宣告
Public Interface IDTSExecuteSQL
'用途
Dim instance As IDTSExecuteSQL
public interface IDTSExecuteSQL
public interface class IDTSExecuteSQL
type IDTSExecuteSQL =  interface end
public interface IDTSExecuteSQL

IDTSExecuteSQL 型別公開下列成員。

屬性

  名稱 說明
公用屬性 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.

上層

請參閱

參考

Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask 命名空間