Freigeben über

ExecuteSQLTask-Klasse

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.

Vererbungshierarchie

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 (in Microsoft.SqlServer.SQLTask.dll)

Syntax

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

Der ExecuteSQLTask-Typ macht folgende Elemente verfügbar.

Konstruktoren

  Name Beschreibung
Öffentliche Methode ExecuteSQLTask Initializes a new instance of the ExecuteSQLTask class.

Zum Anfang

Eigenschaften

  Name Beschreibung
Öffentliche Eigenschaft 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).
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft ExecutionValue Returns the number of rows affected by the SQL statement or statements. (Überschreibt Task.ExecutionValue.)
Öffentliche Eigenschaft IsStoredProcedure Gets or sets a Boolean that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure.
Öffentliche Eigenschaft ParameterBindings Returns an object that implements IDTSParameterBindings.
Öffentliche Eigenschaft ResultSetBindings Returns an object that implements IDTSParameterBindings.
Öffentliche Eigenschaft ResultSetType Gets or sets a value that indicates the type of result set returned by the SQL statement that the Execute SQL tasks runs.
Öffentliche Eigenschaft SqlStatementSource Gets or sets the name of the source that contains the SQL statement that the Execute SQL task runs.
Öffentliche Eigenschaft SqlStatementSourceType Gets or sets a value that indicates the type of source that contains the SQL statement that the Execute SQL task runs.
Öffentliche Eigenschaft TimeOut Gets or sets an integer that indicates the maximum number of seconds the task can run before timing out.
Öffentliche Eigenschaft TypeConversionMode Gets or sets the conversion mode used by the Execute SQL Task.
Öffentliche Eigenschaft Version *** Member deprecated; see Remarks. ***    Returns the version of the task. This property is read-only. (Geerbt von Task.)

Zum Anfang

Methoden

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

Zum Anfang

Hinweise

For more information about the features of this task, see SQL ausführen (Task).

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.

Siehe auch

Verweis

Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask-Namespace

  • Last updated on