• Article

Classe ExecuteSQLTask

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.

Hiérarchie d'héritage

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

Espace de noms :  Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
Assembly :  Microsoft.SqlServer.SQLTask (en Microsoft.SqlServer.SQLTask.dll)

Syntaxe

'Déclaration
<GuidAttribute("3E0AAEAA-F8DC-370D-9206-0FC456CE748F")> _
Public Class ExecuteSQLTask _
    Inherits Task _
    Implements IDTSExecuteSQL, IDTSComponentPersist
'Utilisation
Dim instance As ExecuteSQLTask

[GuidAttribute("3E0AAEAA-F8DC-370D-9206-0FC456CE748F")]
public class ExecuteSQLTask : Task, 
    IDTSExecuteSQL, IDTSComponentPersist

[GuidAttribute(L"3E0AAEAA-F8DC-370D-9206-0FC456CE748F")]
public ref class ExecuteSQLTask : public Task, 
    IDTSExecuteSQL, IDTSComponentPersist

[<GuidAttribute("3E0AAEAA-F8DC-370D-9206-0FC456CE748F")>]
type ExecuteSQLTask =  
    class
        inherit Task
        interface IDTSExecuteSQL
        interface IDTSComponentPersist
    end

public class ExecuteSQLTask extends Task implements IDTSExecuteSQL, IDTSComponentPersist

Le type ExecuteSQLTask expose les membres suivants.

Constructeurs

  Nom Description
Méthode publique ExecuteSQLTask Initializes a new instance of the ExecuteSQLTask class.

Haut de la page

Propriétés

  Nom Description
Propriété publique 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).
Propriété publique 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.
Propriété publique 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.
Propriété publique ExecutionValue Returns the number of rows affected by the SQL statement or statements. (remplace Task. . :: . .ExecutionValue.)
Propriété publique IsStoredProcedure Gets or sets a Boolean that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure.
Propriété publique ParameterBindings Returns an object that implements IDTSParameterBindings.
Propriété publique ResultSetBindings Returns an object that implements IDTSParameterBindings.
Propriété publique ResultSetType Gets or sets a value that indicates the type of result set returned by the SQL statement that the Execute SQL tasks runs.
Propriété publique SqlStatementSource Gets or sets the name of the source that contains the SQL statement that the Execute SQL task runs.
Propriété publique SqlStatementSourceType Gets or sets a value that indicates the type of source that contains the SQL statement that the Execute SQL task runs.
Propriété publique TimeOut Gets or sets an integer that indicates the maximum number of seconds the task can run before timing out.
Propriété publique Version *** Member deprecated; see Remarks. ***    Returns the version of the task. This property is read-only. (hérité de Task.)

Haut de la page

Méthodes

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

Haut de la page

Notes

For more information about the features of this task, see Tâche d'exécution SQL SSIS.

Sécurité des threads

Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.