ScriptComponent.ReleaseConnections Method

Article
12/15/2008

Releases a connection to a connection manager.

Espace de noms: Microsoft.SqlServer.Dts.Pipeline
Assembly: Microsoft.SqlServer.TxScript (in microsoft.sqlserver.txscript.dll)

Syntaxe

'Déclaration
Public Overridable Sub ReleaseConnections

public virtual void ReleaseConnections ()

public:
virtual void ReleaseConnections ()

public void ReleaseConnections ()

public function ReleaseConnections ()

Notes

The Script component developer does not use the ScriptComponent class directly, but indirectly, by coding the methods and properties of the ScriptMain class, which inherits from ScriptComponent through the UserComponent class.

The developer can override the ReleaseConnections method in the ScriptMain class to disconnect from an external data source in a source or destination component.

Exemple

The following code sample shows how a Script component developer might use the ReleaseConnections method to release a connection previously opened during the call to the AcquireConnections method.

Dim connMgr As IDTSConnectionManager90
Dim sqlConn As SqlConnection
...
Public Overrides Sub ReleaseConnections()

  connMgr.ReleaseConnection(sqlConn)

End Sub

Sécurité des threads

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

ScriptComponent Class
ScriptComponent Members
Microsoft.SqlServer.Dts.Pipeline Namespace

Partager via