This topic has not yet been rated - Rate this topic

IDTSDesigntimeComponent100.AcquireConnections Method

SQL Server 2008

SQL Server 2008 R2

Establishes a connection to a connection manager.

Namespace: Microsoft.SqlServer.Dts.Pipeline.Wrapper
Assembly: Microsoft.SqlServer.DTSPipelineWrap (in Microsoft.SqlServer.DTSPipelineWrap.dll)

Syntax

C++

JScript

Copy

void AcquireConnections(
	Object pTransaction
)

Parameters

pTransaction: Type: System.Object
The transaction associated with the connection.

Remarks

AcquireConnections is called during both component design and execution. Components that connect to external data sources should establish their connections by using this method. Any connection established during this method should be cached in a local member variable, and released during the ReleaseConnections method.

Reference

IDTSDesigntimeComponent100 Interface

IDTSDesigntimeComponent100 Members

Microsoft.SqlServer.Dts.Pipeline.Wrapper Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ