Execute SQL Command

The Run Tool has the capability to execute a SQL command/statement.

Add Step

To add the step to your Run Tool Project click onto the Add Step button and select Execute SQL from the list. Enter in a name for the step and click OK.

Execute SQL Step

Configuration

This will then open the configuration window. Enter in the required parameters and click OK to add the step.

Configuration

Setting	Description
Data Provider	Select the correct data provider for your connection.
Connection String	The connection string to the SQL Database.
Command Timeout	The timeout of the command.
SQL Command	The SQL statement to be executed.

The step will then be added to the bottom of your project, move this to where you need it to be, set the run condition and save the project.