Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Integration Services
Technical Reference
Microsoft.SqlServer.Dts.Pipeline
PipelineComponent Class
PipelineComponent Methods
AcquireConnections Method
AddErrorOutput Method
BufferTypeToDataRecordType Method
Cleanup Method
ConvertBufferDataTypeToFitManaged Method
DataRecordTypeToBufferType Method
DeleteExternalMetadataColumn Method
DeleteInput Method
DeleteOutput Method
DeleteOutputColumn Method
DescribeRedirectedErrorCode Method
GetErrorOutputInfo Method
idxOfBufferType Method
idxOfDataRecordType Method
Initialize Method
InsertExternalMetadataColumnAt Method
InsertInput Method
InsertOutput Method
InsertOutputColumnAt Method
IsCompatibleNumericTypes Method
MapInputColumn Method
MapOutputColumn Method
OnDeletingInputColumn Method
OnInputPathAttached Method
OnInputPathDetached Method
OnOutputPathAttached Method
PerformUpgrade Method
PostExecute Method
PreExecute Method
PrepareForExecute Method
PrimeOutput Method
ProcessInput Method
ProvideComponentProperties Method
RegisterEvents Method
RegisterLogEntries Method
ReinitializeMetaData Method
ReleaseConnections Method
RemoveAllInputsOutputsAndCustomProperties Method
SetComponentProperty Method
SetExternalMetadataColumnDataTypeProperties Method
SetExternalMetadataColumnProperty Method
SetInputColumnProperty Method
SetInputProperty Method
SetOutputColumnDataTypeProperties Method
SetOutputColumnProperty Method
SetOutputProperty Method
SetUsageType Method
Validate Method
Expand Minimize
This topic has not yet been rated - Rate this topic

PipelineComponent.ReleaseConnections Method

SQL Server 2008 R2

Frees the connections established during AcquireConnections. Called at design time and run time.

Namespace:  Microsoft.SqlServer.Dts.Pipeline
Assembly:  Microsoft.SqlServer.PipelineHost (in Microsoft.SqlServer.PipelineHost.dll)
C#
C++
F#
JScript
VB
Copy 
public virtual void ReleaseConnections()

Called repeatedly during component design, and at the end of component execution. Components should release any connections that were opened and maintained in AcquireConnections.

C#
VB
Copy 
private System.Data.OleDb.OleDbConnection oledbConnection;
public override void ReleaseConnections()
{
    if (oledbConnection != null && oledbConnection.State != ConnectionState.Closed )
        oledbConnection.Close();
}
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.