DTS_E_CACHELOADEDFROMFILE

Details

Product Name	SQL Server
Product Version	10.0
Product Build Number
Event ID	-1071607021
Event Source	SSIS
Component	Integration Services
Symbolic Name	DTS_E_CACHELOADEDFROMFILE
Message Text	The __ cannot write to the cache because the cache has been loaded from a file by __.

Explanation

The package cannot run because a Cache Transform transformation is trying to write data to the in-memory cache. However, a Cache connection manager has already loaded a cache file into the in-memory cache. Therefore, the package cannot be run.

The hexadecimal value for this error number is 0xC0209313.

Possible Causes

There are multiple data flows. In one data flow, a Lookup transformation uses a Cache connection manager to load a reference data set from a cache file (.raw) into the in-memory cache. In the other data flow, a Cache Transform transformation writes data to the same Cache connection manager. The data flow that contains the Lookup transformation runs before the data flow that contains the Cache Transform transformation.

User Action

Use a precedence constraint to connect the data flow that contains the Cache Transform transformation to the data flow that contains the Lookup transformation. A precedence constraint ensures that the data flow that contains the Cache Transform transformation finishes before the data flow that contains the Lookup transformation runs.