After SQL (node)

Use this property to specify the SQL statement that is run once per node or logical processor that can be a computer or a partition on a computer after all data is processed.

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 this SQL statement to be run once for the entire job after all parallel processing completes, use the After 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.