ExecuteSQLTask ExecuteSQLTask ExecuteSQLTask Class

Definition

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.

public ref class ExecuteSQLTask : Microsoft::SqlServer::Dts::Runtime::Task, Microsoft::SqlServer::Dts::Runtime::IDTSComponentPersist, Microsoft::SqlServer::Dts::Tasks::ExecuteSQLTask::IDTSExecuteSQL
[Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.executesqltask.F1", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.Localized), RequiredProductLevel=Microsoft.SqlServer.Dts.Runtime.DTSProductLevel.None, SamplesTag="SsisExecuteSqlTask", TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2017; © 2017 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.SQLTaskUI, Microsoft.SqlServer.SQLTaskUI, Version=14.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")]
[System.Runtime.InteropServices.Guid("855117DC-EA42-4532-8D53-8E4FC09662CE")]
public class ExecuteSQLTask : Microsoft.SqlServer.Dts.Runtime.Task, Microsoft.SqlServer.Dts.Runtime.IDTSComponentPersist, Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.IDTSExecuteSQL
Public Class ExecuteSQLTask
Inherits Task
Implements IDTSComponentPersist, IDTSExecuteSQL
Inheritance
ExecuteSQLTaskExecuteSQLTaskExecuteSQLTask
Derived
Attributes
Implements

Remarks

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

Constructors

ExecuteSQLTask() ExecuteSQLTask() ExecuteSQLTask()

Initializes a new instance of the ExecuteSQLTask class.

Properties

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

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

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

ExecutionValue ExecutionValue ExecutionValue

Returns the number of rows affected by the SQL statement or statements.

IsStoredProcedure IsStoredProcedure IsStoredProcedure

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

ParameterBindings ParameterBindings ParameterBindings

Returns an object that implements IDTSParameterBindings.

ResultSetBindings ResultSetBindings ResultSetBindings

Returns an object that implements IDTSParameterBindings.

ResultSetType ResultSetType ResultSetType

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

SqlStatementSource SqlStatementSource SqlStatementSource

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

SqlStatementSourceType SqlStatementSourceType SqlStatementSourceType

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

TargetServerVersion TargetServerVersion TargetServerVersion Inherited from Task
TimeOut TimeOut TimeOut

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

TypeConversionMode TypeConversionMode TypeConversionMode

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

Version Version Version

\* Member deprecated; see Remarks. ***** Returns the version of the task. This property is read-only.

(Inherited from Task)

Methods

CanUpdate(String) CanUpdate(String) CanUpdate(String)

\* Member deprecated; see Remarks. ***** A Boolean that indicates whether the new package XML can update the old package XML.

(Inherited from Task)
Equals(Object) Equals(Object) Equals(Object)

Determines whether two object instances are equal.

(Inherited from DtsObject)
Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object) Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object) Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object)

Runs the task.

GetConnectionID(Connections, String) GetConnectionID(Connections, String) GetConnectionID(Connections, String)

Gets a String containing the ID of the connection.

(Inherited from Task)
GetConnectionName(Connections, String) GetConnectionName(Connections, String) GetConnectionName(Connections, String)

Gets a String containing the name of the connection.

(Inherited from Task)
GetHashCode() GetHashCode() GetHashCode()

Returns the hash code for this instance.

(Inherited from DtsObject)
InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker) InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker) InitializeTask(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.

LoadFromXML(XmlElement, IDTSInfoEvents) LoadFromXML(XmlElement, IDTSInfoEvents) LoadFromXML(XmlElement, IDTSInfoEvents)

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

SaveToXML(XmlDocument, IDTSInfoEvents) SaveToXML(XmlDocument, IDTSInfoEvents) SaveToXML(XmlDocument, IDTSInfoEvents)

This method is not callable by your application code. To save a package as .xml, use the SaveToXml(String, Package, IDTSEvents) method.

Update(String) Update(String) Update(String)

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

(Inherited from Task)
Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging) Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging) Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging)

Verifies that the task is properly configured.

Applies to