ConnectionManagerCacheClass Class

Definition

Represents a connection manager that utilizes a Cache Transform or a cache file for the data connection.

public ref class ConnectionManagerCacheClass : Microsoft::SqlServer::Dts::Runtime::Wrapper::ConnectionManagerCache, Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSConnectionManagerCache100
[System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)]
[System.Runtime.InteropServices.Guid("1090CB9C-6284-4C21-B90C-64EA62B1B51A")]
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)]
public class ConnectionManagerCacheClass : Microsoft.SqlServer.Dts.Runtime.Wrapper.ConnectionManagerCache, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManagerCache100
[System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)]
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)]
[System.Runtime.InteropServices.Guid("31F57986-C399-4A9C-9EAA-6FE712276A7C")]
public class ConnectionManagerCacheClass : Microsoft.SqlServer.Dts.Runtime.Wrapper.ConnectionManagerCache, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManagerCache100
[System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)]
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)]
[System.Runtime.InteropServices.Guid("1D3BE38B-89AB-4267-B5F4-3C546A4D2302")]
public class ConnectionManagerCacheClass : Microsoft.SqlServer.Dts.Runtime.Wrapper.ConnectionManagerCache, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManagerCache100
[<System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)>]
[<System.Runtime.InteropServices.Guid("1090CB9C-6284-4C21-B90C-64EA62B1B51A")>]
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)>]
type ConnectionManagerCacheClass = class
    interface IDTSConnectionManager100
    interface ConnectionManagerCache
    interface IDTSConnectionManagerCache100
[<System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)>]
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)>]
[<System.Runtime.InteropServices.Guid("31F57986-C399-4A9C-9EAA-6FE712276A7C")>]
type ConnectionManagerCacheClass = class
    interface IDTSConnectionManager100
    interface ConnectionManagerCache
    interface IDTSConnectionManagerCache100
[<System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)>]
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)>]
[<System.Runtime.InteropServices.Guid("1D3BE38B-89AB-4267-B5F4-3C546A4D2302")>]
type ConnectionManagerCacheClass = class
    interface IDTSConnectionManager100
    interface ConnectionManagerCache
    interface IDTSConnectionManagerCache100
Public Class ConnectionManagerCacheClass
Implements ConnectionManagerCache, IDTSConnectionManagerCache100
Inheritance
ConnectionManagerCacheClass
Attributes
Implements

Remarks

For more information, see ConnectionManager.

Constructors

ConnectionManagerCacheClass()

Initializes a new instance of the ConnectionManagerCacheClass class.

Properties

Columns

Gets or sets the columns in the cache.

ConnectionString

Gets or sets the connection string used to establish a connection to a data source.

ProtectionLevel

Gets or sets the level of encryption performed on sensitive data that is contained in the package.

RetainData

Gets or sets a Boolean that indicates whether the connection manager retains the data in the cache.

Scope

Gets the scope of the connection manager.

SupportsDTCTransactions

Gets a Boolean that indicates whether the connection supports Microsoft Distributed Transaction Coordinator (MS DTC) transactions.

UseEncryption

Gets or sets a Boolean that indicates whether to use encryption.

UseFile

Gets or sets a Boolean that indicates whether the connection manager uses a cache file.

Methods

AcquireConnection(Object)

Creates an instance of the connection type.

GetFileColumns(String)

Reads and returns the columns from the specified cache file.

ReleaseConnection(Object)

Frees the connection established during AcquireConnection(Object). Called at design time and runtime.

SetQualifier(String)

Changes a qualifier on the connection manager after the connection manager has been created but before it is used in a running package.

Validate(IDTSInfoEvents100)

Validates the connection and returns an enumeration that indicates success or failure.

Applies to