Export (0) Print
Expand All

DTS_E_CACHELOADEDFROMFILE

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 __.

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft