This topic has not yet been rated - Rate this topic

DTS_E_MULTIPLECACHEWRITES

SQL Server 2008 R2

SQL Server 2008

Product Name	SQL Server
Product Version	10.0
Product Build Number
Event ID	-1073675776
Event Source	SSIS
Component	Integration Services
Symbolic Name	DTS_E_MULTIPLECACHEWRITES
Message Text	The __ cannot write to the cache because __ has already written to it.

Explanation

The package cannot run because a Cache Transform transformation is trying to write data to the in-memory cache. However, another Cache Transform transformation has already written to the in-memory cache.

The hexadecimal value for this error number is 0xC0010200.

Possible Causes

In a single package, there are multiple Cache Transform transformations that are configured to write data to the same Cache connection manager.

User Action

Remove the additional Cache Transform transformations from the package, or re-configure the additional Cache Transform transformations to write data to different Cache connection managers.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD