Close SQL Connection—Setting Properties

The Close SQL Connection action is used to close a SQL connection and end a SQL session started by and earlier Open SQL Connection action.

To set Close SQL Connection properties

  1. From the Task Builder Available Actions pane, open the Database folder and double-click the Close SQL Connection action or drag it into the Steps pane. The following dialog appears:

  1. In the Session name box, select the name of the session you want to close.

  2. To set the Description tab properties, refer to Description Tab Options.

  3. To set the Error Causes and On Error tab properties, refer to Step Error Handling.

  4. When finished, click OK to save settings and close the properties dialog window.

See Also

About Actions

Adding Task Steps

Close SQL Connection Action