Dela via

  • Artikel

DTS_E_WRITEWHILECACHEINUSE

Details

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

Explanation

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

User Action

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.