This task will execute a non-result generating query against SQL Server. It is typically used for stored procedures, insert, update and delete commands.
The maximum time to wait for the query to execute.
The SQL Query to be executed e.g.
UPDATE Customers SET CreditLimit = 1000 WHERE Turnover > 10000
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
Name of the file containing parameters if using parameterized queries.
See Common Task Settings
You can find an example of how to use this task in the SQL Server Connector tutorial.
Sample query, which will update an existing record in the database:
UPDATE Orders SET Status = 'Processed' WHERE OrderId = 1
Back | Edit on Github