This action opens a SQL Server connection using the defined connection string, and adds the connection to the Update Context Shared Properties collection. Other SQL Server update actions can use the connection. The connection can also be accessed from custom or dynamic code action through the Update Context Shared Properties collection.
The connection string can be read from a .net config file, or defined explicitly. Shared properties can also be used to define the connection string. Using Shared Properties, the connection string can be passed in from the host application using an ApplyUpdate method overload, or retrieved from the host computer using an xml or registry action and assigned to a Shared Property, which can be used to define the connection string.
The connection can be designated to be exclusive by placing the database in single-user mode prior to opening the connection.
Prepare Stage
No action taken.
Execute Stage
The SQL Server connection is opened and added to the Shared Properties collection. If designated, the database is placed in single user mode.
Cleanup Stage
No action taken.
Rollback Stage
If the connection is present and still open, the connection is closed. Otherwise no action is taken.