共用方式為


ScriptComponent.ReleaseConnections 方法

Releases a connection to a connection manager.

命名空間:  Microsoft.SqlServer.Dts.Pipeline
組件:  Microsoft.SqlServer.TxScript (在 Microsoft.SqlServer.TxScript.dll 中)

語法

'宣告
Public Overridable Sub ReleaseConnections
'用途
Dim instance As ScriptComponent

instance.ReleaseConnections()
public virtual void ReleaseConnections()
public:
virtual void ReleaseConnections()
abstract ReleaseConnections : unit -> unit  
override ReleaseConnections : unit -> unit
public function ReleaseConnections()

備註

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.

範例

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 IDTSConnectionManager100
Dim sqlConn As SqlConnection
...
Public Overrides Sub ReleaseConnections()

  connMgr.ReleaseConnection(sqlConn)

End Sub

請參閱

參考

ScriptComponent 類別

Microsoft.SqlServer.Dts.Pipeline 命名空間