General

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.