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.
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:
In the Session name box, select the name of the session you want to close.
To set the Description tab properties, refer to Description Tab Options.
To set the Error Causes and On Error tab properties, refer to Step Error Handling.
When finished, click OK to save settings and close the properties dialog window.
Adding Task Steps
Close SQL Connection Action