Skip to main content

Execute SQL Command

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

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 where you can enter in the required parameters, described in the table below, and then click OK to add the step.

SettingDescription
Data ProviderSelect the correct data provider for your connection.
Connection StringThe connection string to the SQL Database.
Command TimeoutThe timeout of the command.
SQL CommandThe SQL statement to be executed.

Configuration Window

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