This documentation is archived and is not being maintained.

ExecuteSQLTask Members

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.

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

  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

(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).gif ms214876.static(en-US,SQL.90).gif op_Equality  (inherited from DtsObject )
ms214876.pubmethod(en-US,SQL.90).gif ms214876.static(en-US,SQL.90).gif op_Inequality  (inherited from DtsObject )
ms214876.pubmethod(en-US,SQL.90).gif ms214876.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

  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
Show: