Execute Query
Description
The Execute Query activity runs a raw SQL statement against a connected database. It enables advanced operations and custom queries beyond standard insert, update, select, and delete.
Design-Time Configuration
The following properties define how the activity connects to the database and executes the SQL query.
Connection Type
Specifies the database engine (for example, SQL Server, Oracle, MySQL, PostgreSQL). Selecting the correct type ensures compatibility with the target database.
Connection Name
Select a preconfigured database connection that defines the server, credentials, and security settings.
Query
Specifies the SQL statement to be executed. The Query must be valid for the selected database type and may return a result set or perform data modification operations.
Timeout
Specifies the maximum time (in seconds) that the activity will wait for the Query to complete. The default value is 600 seconds.
Wait All Incoming
The Wait All Incoming property controls how the activity behaves when it has multiple incoming execution paths.
| Option | Description |
|---|---|
| False | The activity executes whenever any incoming path completes. Each incoming completion can trigger a separate execution. |
| All Configured Incoming | The activity executes only after all design-time (configured) incoming paths have completed. If a path is skipped at runtime due to conditional logic, the activity may wait indefinitely. |
| All Active Incoming | The activity executes only after all runtime-active incoming paths have completed. Incoming paths that are not taken due to conditions are ignored, ensuring predictable execution. |
Outputs
Output
Returns the result produced by the SQL query.
For queries that return data (for example, SELECT), this output contains the result set.
For data-modifying queries (for example, INSERT, UPDATE, DELETE), it may return the number of affected rows or the execution status.
Error Handling
This activity supports the standard On Error handler, including Fault, Continue, Suspend, and Retry.
For details, see On Error Handler.