Sunday, August 23, 2015

Error"[Lookup [102]] Error: The cache is being written to by Cache Transform, and cannot be read by Lookup" when using Cache Transform


The package fails with the error:
[Lookup [102]] Error: The cache is being written to by Cache Transform, and cannot be read by Lookup.
[Lookup [102]] Error: Failed to prepare the cache for providing data.
[SSIS.Pipeline] Error: Lookup failed the pre-execute phase and returned error code 0xC0010204.

The package fails because cache transform and lookup are used in the same data flow.Cache transform and Lookup need to be in different data flow with precedence constraint on Cache transform data flow for the package to work.

Resolved Package:

 Data Flow with Cache Transform:
Data Flow with Lookup:



Posted by at

1 comment:

  1. James ZicrovAugust 22, 2020 at 3:30 AM

    I feel SSIS and other tough and complicated problems actually help one find more about some complex and useful IT problems.It is mostly useful for creating dashboards and reports for end users.

    SSIS Upsert

    ReplyDelete

Subscribe to: Post Comments (Atom)