Close SQL Connection Action

Declaration

<AMSQLCLOSECONNECTION SESSION="Text" />

See Also

Close SQL Connection-Setting Properties, Open SQL Connection Action, Execute SQL Query Action, Execute Stored Procedure Action

Description

Closes a previously established connection created by an Open SQL Connection step.

Practical Usage

Used to terminate a previously opened SQL session.

Parameters

General Tab

Session Name

Text, Optional - Default "SQLSession1"
MARKUP: SESSION="SQLSession2"

Specifies the session name of the connection to close. If only one SQL session was created and the default session name was used to open it (recommended), use the default setting.

Notes

Custom Description

This action includes the Description tab for entering a custom step description.

More on setting custom step description

Standard Error Handling Options

This action also includes the standard Error Causes and On Error failure handling options/tabs.

More on Error Handling Options

Variables and Expressions

All text fields allow the use of expressions, which can be entered by surrounding the expression in percentage signs (example: %MYVARIABLE%, %Left('Text',2)%). To help construct these expressions, you can open Expression Builder from these fields by pressing F2.

More on variables
More on expressions

More on the expression builder

Examples

NOTE: The code below can be copied and pasted directly into the Steps pane of the Task Builder.

<AMSQLCLOSECONNECTION SESSION="SQLSession2" />