Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 | |
|---|---|---|
.gif "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). |
|
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 | 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 | Overridden. Returns the number of rows affected by the SQL statement or statements. |
|
IsStoredProcedure | Gets or sets a Boolean that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure. |
|
ParameterBindings | Returns an object that implements IDTSParameterBindings. |
|
ResultSetBindings | Returns an object that implements IDTSParameterBindings. |
|
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 | Gets or sets the name of the source that contains the SQL statement that the Execute SQL task runs. |
|
SqlStatementSourceType | Gets or sets a value that indicates the type of source that contains the SQL statement that the Execute SQL task runs. |
|
TimeOut | Gets or sets an integer that indicates the maximum number of seconds the task can run before timing out. |
|
Version | Returns the version of the task. This property is read-only. (inherited from Task) |
|
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 | |
|---|---|---|
.gif "ms214876.pubmethod(en-US,SQL.90).gif") |
CanUpdate | (inherited from Task ) |
|
Equals | Overloaded. (inherited from DtsObject ) |
|
Execute | Overridden. Runs the task. |
|
GetConnectionID | (inherited from Task ) |
|
GetConnectionName | (inherited from Task ) |
|
GetHashCode | Returns the hash code for this instance. (inherited from DtsObject) |
|
GetType | (inherited from Object ) |
|
InitializeTask | Overridden. Initializes the properties associated with the Execute SQL task. This method is called by the runtime and is not used in code. |
|
LoadFromXML | This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method. |
.gif "ms214876.static(en-US,SQL.90).gif") |
op_Equality | (inherited from DtsObject ) |
|
op_Inequality | (inherited from DtsObject ) |
|
ReferenceEquals | (inherited from Object ) |
|
SaveToXML | This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method. |
|
ToString | (inherited from Object ) |
|
Update | (inherited from Task ) |
|
Validate | Overridden. Verifies that the task is properly configured. |
Top
Protected Methods
| Name | Description | |
|---|---|---|
.gif "ms214876.protmethod(en-US,SQL.90).gif") |
Finalize | (inherited from Object ) |
|
MemberwiseClone | (inherited from Object ) |
Top
See Also
Reference
ExecuteSQLTask Class
Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask Namespace