Distributed Cache Connection

SQL Server 2005, 2008, 2008R2, 2012, 2014

SQL Server 2005, 2008, 2008R2, 2012, 2014

All Downloads ----- Join VIP ----- Questions?

Overview

Distributed Cache Connection Manager is SSIS Connection Manager for establishing connections with Microsoft Windows Server AppFabric Cache. The connection manager is based and requires installation of Windows AppFabric client. Use the API to build components based on Distributed Cache Connection Manager.


Setup

Use the Distributed Cache Connection Manager dialog to specify properties for connecting to Windows AppFabric Cache service.

Server Options

Configuration file

Specify cache configuration file.

Cache name:

Specify cache name. This parameter is optional. If not specified, the manager will return the default cache.

Region:

Specify region inside cache. This parameter is optional.

RetainSameConnection

Specify if all clients should use the same connection. This property has the options listed in the following table.

Value Description
True All clients use same connection (default).
False Every client use different connection.
Test Connection

Confirm connection manager configuration by clicking Test Connection.

How to populate cache with data?

You can use Dictionary Destination script component to insert items in cache.