Before SQL (node)

Use this property to specify the SQL statement that is run before any data is processed. The statement is run once per node or logical processor.

This property is available only if you set Before/After SQL to Yes.

You can type more than one statement in this property. Separate each statement with a semicolon (;). Use the Fail on error property to specify whether the job stops when an error occurs.

To specify that this SQL statement is run once for the entire job before all parallel processing completes, use the Before SQL property instead of this property.

Click ellipses button to open a statement window in which to type your SQL statement. This button is available only when you click inside the property.

Valid values are determined by the specific database.