Export (0) Print
Expand All

ExecuteSQLTask Class

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.

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)

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

The ExecuteSQLTask type exposes the following members.

  NameDescription
Public methodExecuteSQLTaskInitializes a new instance of the ExecuteSQLTask class.
Top

  NameDescription
Public propertyBypassPrepareGets 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).
Public propertyCodePageGets 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.
Public propertyConnectionGets or sets the name of the connection manager that connects to the relational database management system (RDBMS) where the Execute SQL task is run.
Public propertyExecutionValueReturns the number of rows affected by the SQL statement or statements. (Overrides Task.ExecutionValue.)
Public propertyIsStoredProcedureGets or sets a Boolean that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure.
Public propertyParameterBindingsReturns an object that implements IDTSParameterBindings.
Public propertyResultSetBindingsReturns an object that implements IDTSParameterBindings.
Public propertyResultSetTypeGets or sets a value that indicates the type of result set returned by the SQL statement that the Execute SQL tasks runs.
Public propertySqlStatementSourceGets or sets the name of the source that contains the SQL statement that the Execute SQL task runs.
Public propertySqlStatementSourceTypeGets or sets a value that indicates the type of source that contains the SQL statement that the Execute SQL task runs.
Public propertyTimeOutGets or sets an integer that indicates the maximum number of seconds the task can run before timing out.
Public propertyVersion*** Member deprecated; see Remarks. ***   Returns the version of the task. This property is read-only. (Inherited from Task.)
Top

  NameDescription
Public methodCanUpdate*** Member deprecated; see Remarks. ***   A Boolean that indicates whether the new package XML can update the old package XML. (Inherited from Task.)
Public methodEqualsDetermines whether two object instances are equal. (Inherited from DtsObject.)
Public methodExecuteRuns the task. (Overrides Task.Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).)
Protected methodFinalize (Inherited from Object.)
Public methodGetConnectionIDGets a String containing the ID of the connection. (Inherited from Task.)
Public methodGetConnectionNameGets a String containing the name of the connection. (Inherited from Task.)
Public methodGetHashCodeReturns the hash code for this instance. (Inherited from DtsObject.)
Public methodGetType (Inherited from Object.)
Public methodInitializeTaskInitializes 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).)
Public methodLoadFromXMLThis method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
Protected methodMemberwiseClone (Inherited from Object.)
Public methodSaveToXMLThis method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
Public methodToString (Inherited from Object.)
Public methodUpdate*** 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.)
Public methodValidateVerifies that the task is properly configured. (Overrides Task.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).)
Top

For more information about the features of this task, see SSIS 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.

Community Additions

ADD
Show:
© 2014 Microsoft