This task will execute a non-result generating query against an SQLite database. It is typically used for stored procedures, insert, update and delete commands.
The SQL query to be executed e.g.
UPDATE Customers SET CreditLimit = 1000 WHERE Turnover > 10000
The SQLite Connection to use. See the Connecting to an SQLite Database 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.
A sample query is shown below, which will update the
Status of an existing record in the
Orders table of the database.
UPDATE Orders SET Status = 'Processed' WHERE OrderId = 1
Back | Edit on Github