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.