Export (0) Print
Expand All

ExecuteSQLTask Class

 

Applies To: SQL Server 2016 Preview

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.

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

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

[GuidAttribute("53A0FC2A-0360-4F76-846A-35493E6BA762")]
public class ExecuteSQLTask : Task, IDTSExecuteSQL, IDTSComponentPersist

NameDescription
System_CAPS_pubmethodExecuteSQLTask()

Initializes a new instance of the ExecuteSQLTask class.

NameDescription
System_CAPS_pubpropertyBypassPrepare

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).

System_CAPS_pubpropertyCodePage

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.

System_CAPS_pubpropertyConnection

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.

System_CAPS_pubpropertyExecutionValue

Returns the number of rows affected by the SQL statement or statements.(Overrides Task.ExecutionValue.)

System_CAPS_pubpropertyIsStoredProcedure

Gets or sets a Boolean that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure.

System_CAPS_pubpropertyParameterBindings

Returns an object that implements IDTSParameterBindings.

System_CAPS_pubpropertyResultSetBindings

Returns an object that implements IDTSParameterBindings.

System_CAPS_pubpropertyResultSetType

Gets or sets a value that indicates the type of result set returned by the SQL statement that the Execute SQL tasks runs.

System_CAPS_pubpropertySqlStatementSource

Gets or sets the name of the source that contains the SQL statement that the Execute SQL task runs.

System_CAPS_pubpropertySqlStatementSourceType

Gets or sets a value that indicates the type of source that contains the SQL statement that the Execute SQL task runs.

System_CAPS_pubpropertyTimeOut

Gets or sets an integer that indicates the maximum number of seconds the task can run before timing out.

System_CAPS_pubpropertyTypeConversionMode

Gets or sets the conversion mode used by the Execute SQL Task.

System_CAPS_pubpropertyVersion

*** Member deprecated; see Remarks. ***   Returns the version of the task. This property is read-only.(Inherited from Task.)

NameDescription
System_CAPS_pubmethodCanUpdate(String)

*** Member deprecated; see Remarks. ***   A Boolean that indicates whether the new package XML can update the old package XML.(Inherited from Task.)

System_CAPS_pubmethodEquals(Object)

Determines whether two object instances are equal.(Inherited from DtsObject.)

System_CAPS_pubmethodExecute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object)
System_CAPS_protmethodFinalize()

(Inherited from Object.)

System_CAPS_pubmethodGetConnectionID(Connections, String)

Gets a String containing the ID of the connection.(Inherited from Task.)

System_CAPS_pubmethodGetConnectionName(Connections, String)

Gets a String containing the name of the connection.(Inherited from Task.)

System_CAPS_pubmethodGetHashCode()

Returns the hash code for this instance.(Inherited from DtsObject.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodInitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker)

Initializes the properties associated with the Execute SQL task. This method is called by the runtime and is not used in code.(Overrides Task.InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker).)

System_CAPS_pubmethodLoadFromXML(XmlElement, IDTSInfoEvents)

This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.

System_CAPS_protmethodMemberwiseClone()

(Inherited from Object.)

System_CAPS_pubmethodSaveToXML(XmlDocument, IDTSInfoEvents)

This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.

System_CAPS_pubmethodToString()

(Inherited from Object.)

System_CAPS_pubmethodUpdate(String)

*** Member deprecated; see Remarks. ***   This method updates the old package XML with the new package XML if CanUpdate is set to true.(Inherited from Task.)

System_CAPS_pubmethodValidate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging)

Verifies that the task is properly configured.(Overrides Task.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).)

For more information about the features of this task, see Execute SQL Task.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft