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.


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

Server Parameters

Specify cache configuration file.

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

Specify region inside cache. This parameter is optional.

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.