Condividi tramite

Classe ExecuteSQLTask

  • Articolo

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.

Gerarchia di ereditarietà

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

Spazio dei nomi  Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
Assembly:  Microsoft.SqlServer.SQLTask (in Microsoft.SqlServer.SQLTask.dll)

Sintassi

'Dichiarazione
<GuidAttribute("C876C481-2EA3-40E1-9D75-5F73D0BED1D4")> _
Public Class ExecuteSQLTask _
    Inherits Task _
    Implements IDTSExecuteSQL, IDTSComponentPersist
'Utilizzo
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

Nel tipo ExecuteSQLTask sono esposti i membri seguenti.

Costruttori

  Nome Descrizione
Metodo pubblico ExecuteSQLTask Initializes a new instance of the ExecuteSQLTask class.

In alto

Proprietà

  Nome Descrizione
Proprietà pubblica 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).
Proprietà pubblica 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.
Proprietà pubblica 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.
Proprietà pubblica ExecutionValue Returns the number of rows affected by the SQL statement or statements. Esegue l'override di Task.ExecutionValue.
Proprietà pubblica IsStoredProcedure Gets or sets a Boolean that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure.
Proprietà pubblica ParameterBindings Returns an object that implements IDTSParameterBindings.
Proprietà pubblica ResultSetBindings Returns an object that implements IDTSParameterBindings.
Proprietà pubblica ResultSetType Gets or sets a value that indicates the type of result set returned by the SQL statement that the Execute SQL tasks runs.
Proprietà pubblica SqlStatementSource Gets or sets the name of the source that contains the SQL statement that the Execute SQL task runs.
Proprietà pubblica SqlStatementSourceType Gets or sets a value that indicates the type of source that contains the SQL statement that the Execute SQL task runs.
Proprietà pubblica TimeOut Gets or sets an integer that indicates the maximum number of seconds the task can run before timing out.
Proprietà pubblica TypeConversionMode Gets or sets the conversion mode used by the Execute SQL Task.
Proprietà pubblica Version *** Member deprecated; see Remarks. ***    Returns the version of the task. This property is read-only. Ereditato da Task.

In alto

Metodi

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

In alto

Osservazioni

For more information about the features of this task, see Attività Esegui SQL.

Protezione dei thread

I membri static (Shared in Visual Basic) pubblici di questo tipo sono affidabili. Non è invece garantita la sicurezza dei membri dell'istanza.

Vedere anche

Riferimento

Spazio dei nomi Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask