MS SQL Execute

This task will execute a non-result generating query against SQL Server. It is typically used for stored procedures, insert, update and delete commands.

Settings

Operation Timeout

Required
The maximum time to wait for the query to execute.

Query

Required
The SQL Query to be executed e.g. UPDATE Customers SET CreditLimit = 1000 WHERE Turnover > 10000

Connection

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

Parameter Input File

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

Zynk Settings

See Common Task Settings

Examples

You can find an example of how to use this task in the Using the SQL Connector tutorial.

Sample query, which will update an existing record in the database:

UPDATE Orders SET Status = 'Processed' WHERE OrderId = 1