Compartilhar via

Classe ExecuteSQLTask

  • Artigo

Contains the members used to configure and run an Execute SQL task. The Execute SQL task is used to execute SQL commands against a relational database table or view.

Hierarquia de herança

System.Object
  Microsoft.SqlServer.Dts.Runtime.DtsObject
    Microsoft.SqlServer.Dts.Runtime.Task
      Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask

Namespace:  Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
Assembly:  Microsoft.SqlServer.SQLTask (em Microsoft.SqlServer.SQLTask.dll)

Sintaxe

'Declaração
<GuidAttribute("C876C481-2EA3-40E1-9D75-5F73D0BED1D4")> _
Public Class ExecuteSQLTask _
    Inherits Task _
    Implements IDTSExecuteSQL, IDTSComponentPersist
'Uso
Dim instance As ExecuteSQLTask

[GuidAttribute("C876C481-2EA3-40E1-9D75-5F73D0BED1D4")]
public class ExecuteSQLTask : Task, 
    IDTSExecuteSQL, IDTSComponentPersist

[GuidAttribute(L"C876C481-2EA3-40E1-9D75-5F73D0BED1D4")]
public ref class ExecuteSQLTask : public Task, 
    IDTSExecuteSQL, IDTSComponentPersist

[<GuidAttribute("C876C481-2EA3-40E1-9D75-5F73D0BED1D4")>]
type ExecuteSQLTask =  
    class 
        inherit Task 
        interface IDTSExecuteSQL 
        interface IDTSComponentPersist 
    end

public class ExecuteSQLTask extends Task implements IDTSExecuteSQL, IDTSComponentPersist

O tipo ExecuteSQLTask expõe os membros a seguir.

Construtores

  Nome Descrição
Método público ExecuteSQLTask Initializes a new instance of the ExecuteSQLTask class.

Início

Propriedades

  Nome Descrição
Propriedade pública BypassPrepare Gets or sets a Boolean that indicates whether the Execute SQL task skips preparation of the statement when sending the SQL statement to the relational database management system (RDBMS).
Propriedade pública CodePage Gets or sets the code page to use when translating variable values that are stored as Unicode wide chars to multi-bytes. Translation occurs either when storing values to or extracting values from databases.
Propriedade pública Connection Gets or sets the name of the connection manager that connects to the relational database management system (RDBMS) where the Execute SQL task is run.
Propriedade pública ExecutionValue Returns the number of rows affected by the SQL statement or statements. (Substitui Task.ExecutionValue.)
Propriedade pública IsStoredProcedure Gets or sets a Boolean that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure.
Propriedade pública ParameterBindings Returns an object that implements IDTSParameterBindings.
Propriedade pública ResultSetBindings Returns an object that implements IDTSParameterBindings.
Propriedade pública ResultSetType Gets or sets a value that indicates the type of result set returned by the SQL statement that the Execute SQL tasks runs.
Propriedade pública SqlStatementSource Gets or sets the name of the source that contains the SQL statement that the Execute SQL task runs.
Propriedade pública SqlStatementSourceType Gets or sets a value that indicates the type of source that contains the SQL statement that the Execute SQL task runs.
Propriedade pública TimeOut Gets or sets an integer that indicates the maximum number of seconds the task can run before timing out.
Propriedade pública TypeConversionMode Gets or sets the conversion mode used by the Execute SQL Task.
Propriedade pública Version *** Member deprecated; see Remarks. ***    Returns the version of the task. This property is read-only. (Herdado de Task.)

Início

Métodos

  Nome Descrição
Método público CanUpdate *** Member deprecated; see Remarks. ***    A Boolean that indicates whether the new package XML can update the old package XML. (Herdado de Task.)
Método público Equals Determines whether two object instances are equal. (Herdado de DtsObject.)
Método público Execute Runs the task. (Substitui Task.Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).)
Método protegido Finalize (Herdado de Object.)
Método público GetConnectionID Gets a String containing the ID of the connection. (Herdado de Task.)
Método público GetConnectionName Gets a String containing the name of the connection. (Herdado de Task.)
Método público GetHashCode Returns the hash code for this instance. (Herdado de DtsObject.)
Método público GetType (Herdado de Object.)
Método público InitializeTask Initializes the properties associated with the Execute SQL task. This method is called by the runtime and is not used in code. (Substitui Task.InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker).)
Método público LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
Método protegido MemberwiseClone (Herdado de Object.)
Método público SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
Método público ToString (Herdado de Object.)
Método público Update *** Member deprecated; see Remarks. ***    This method updates the old package XML with the new package XML if CanUpdate is set to true. (Herdado de Task.)
Método público Validate Verifies that the task is properly configured. (Substitui Task.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).)

Início

Comentários

For more information about the features of this task, see Tarefa Executar SQL.

Segurança de thread

Qualquer membro público static (Shared no Visual Basic) desse tipo é seguro para threads. Não há garantia de que qualquer membro de instância seja seguro para threads.

Consulte também

Referência

Namespace Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask