Execute Query

This task will execute a non-query against OLEDB data source. It is typically used for stored procedures, insert, update and delete commands.

Settings

Query

Required
The SQL query to be executed, see below for an example.

Connection

Required
The OLEDB Connection to use. See the Connecting to an OLEDB Database article if you require more information on how to create/manage connections.

Parameter Input File

Optional
Name of the file containing parameters if using parameterized queries.

Zynk Settings

See Common Task Settings

Examples

Sample query, which will set the CreditLimit in the Customers table to 1000 where the Turnover is greater than 10000:

UPDATE Customers SET CreditLimit = 1000 WHERE Turnover > 10000