ExecuteSQLTask Members

  • Article

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.

The following tables list the members exposed by the ExecuteSQLTask type.

Public Constructors

  Name Description
ExecuteSQLTask Initializes a new instance of the ExecuteSQLTask class.

Top

Public Properties

  Name Description
ms214876.pubproperty(en-US,SQL.90).gif 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).
ms214876.pubproperty(en-US,SQL.90).gif 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.
ms214876.pubproperty(en-US,SQL.90).gif 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.
ms214876.pubproperty(en-US,SQL.90).gif ExecutionValue Overridden. Returns the number of rows affected by the SQL statement or statements.
ms214876.pubproperty(en-US,SQL.90).gif IsStoredProcedure Gets or sets a Boolean that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure.
ms214876.pubproperty(en-US,SQL.90).gif ParameterBindings Returns an object that implements IDTSParameterBindings.
ms214876.pubproperty(en-US,SQL.90).gif ResultSetBindings Returns an object that implements IDTSParameterBindings.
ms214876.pubproperty(en-US,SQL.90).gif ResultSetType Gets or sets a value that indicates the type of result set returned by the SQL statement that the Execute SQL tasks runs.
ms214876.pubproperty(en-US,SQL.90).gif SqlStatementSource Gets or sets the name of the source that contains the SQL statement that the Execute SQL task runs.
ms214876.pubproperty(en-US,SQL.90).gif SqlStatementSourceType Gets or sets a value that indicates the type of source that contains the SQL statement that the Execute SQL task runs.
ms214876.pubproperty(en-US,SQL.90).gif TimeOut Gets or sets an integer that indicates the maximum number of seconds the task can run before timing out.
ms214876.pubproperty(en-US,SQL.90).gif Version  Returns the version of the task. This property is read-only. (inherited from Task)
ms214876.pubproperty(en-US,SQL.90).gif WaitForMe  Returns a Boolean that indicates whether the parent container should wait for completion of this task. This property is read-only. (inherited from Task)

Top

Public Methods

(see also Protected Methods )

  Name Description
ms214876.pubmethod(en-US,SQL.90).gif CanUpdate  (inherited from Task )
ms214876.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from DtsObject )
ms214876.pubmethod(en-US,SQL.90).gif Execute Overridden. Runs the task.
ms214876.pubmethod(en-US,SQL.90).gif GetConnectionID  (inherited from Task )
ms214876.pubmethod(en-US,SQL.90).gif GetConnectionName  (inherited from Task )
ms214876.pubmethod(en-US,SQL.90).gif GetHashCode  Returns the hash code for this instance. (inherited from DtsObject)
ms214876.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms214876.pubmethod(en-US,SQL.90).gif InitializeTask Overridden. Initializes the properties associated with the Execute SQL task. This method is called by the runtime and is not used in code.
ms214876.pubmethod(en-US,SQL.90).gif LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
ms214876.pubmethod(en-US,SQL.90).gifms214876.static(en-US,SQL.90).gif op_Equality  (inherited from DtsObject )
ms214876.pubmethod(en-US,SQL.90).gifms214876.static(en-US,SQL.90).gif op_Inequality  (inherited from DtsObject )
ms214876.pubmethod(en-US,SQL.90).gifms214876.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms214876.pubmethod(en-US,SQL.90).gif SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
ms214876.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )
ms214876.pubmethod(en-US,SQL.90).gif Update  (inherited from Task )
ms214876.pubmethod(en-US,SQL.90).gif Validate Overridden. Verifies that the task is properly configured.

Top

Protected Methods

  Name Description
ms214876.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms214876.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

See Also

Reference

ExecuteSQLTask Class
Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask Namespace