The following fields are general to this transformation step:
| Field | Description |
|---|---|
| Step name | Specify the unique name of the Execute row SQL script step on the canvas. You can customize the name or leave it as the default. |
| Connection | Select the name of a connected database from the list. |
| Edit | Click to edit your current database connection. |
| New | Click to establish a new database connection. |
| Wizard | Click to open a new database connection using the Wizard. |
| Commit | Specify the number of rows to commit at a time. The default is 1. |
| Send a single statement | Clear if you do not want to group rows into a single statement. |
| SQL field name | Specify the field that contains either the SQL statement or the path to the SQL file to execute. |
| Read SQL from file | Select to specify that the SQL field name is the path to an SQL file. |