Export (0) Print
Expand All

DTS_E_WRITEWHILECACHEINUSE

Product Name

SQL Server 

Product Version

10.0

Product Build Number

Event ID

1073675770

Event Source

MSSQLServer

Component

Integration Services 

Symbolic Name

DTS_E_WRITEWHILECACHEINUSE

Message Text

The cache is being read from __ and cannot be written to by __.

A Cache Transform transformation is trying to write data to the in-memory cache at the same time that a Lookup transformation is reading data from the in-memory cache.

The hexadecimal value for this error number is 0xc0010206.

Possible Causes

In a single data flow, a Cache Transform transformation is writing data to a Cache connection manager. At the same time, a Lookup transformation is using the same Cache connection manager to connect to a reference data set by reading the data from a cache file (.raw).

Do one of the following steps:

  • Move the Lookup Transformation or the Cache Transform transformation to another data flow in a separate package.

  • Move the Lookup Transformation or the Cache Transform transformation to another data flow in the same package. Because the data flows are in the same package, connect them by using a precedence constraint. 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