CODEWITHSUNDEEP
ssisssis-2008
Builder
Builder

Reputation: 1056

SSIS - Lookup - cache is not initialized and cannot be read

I am getting this error continuously and have no idea about the cause.

Error: The cache is not initialized and cannot be read by component "Lookup " Error: Failed to prepare the cache for providing data. [SSIS.Pipeline] Error: component "Lookup UBN-StatTypeID" (2021) failed the pre-execute phase and returned error code 0xC0010204.

enter image description here

Upvotes: 1

Views: 4217

Answers (2)

SebTHU
SebTHU

Reputation: 1405

If you want to use the Cache Connection Manager, the cache must be populated before the lookup operation, using a Cache Transformation inside a DataFlow.

This error suggests that it's that previous operation which has failed, not a problem with the Lookup Transformation itself.

Upvotes: 3

user2460074
user2460074

Reputation: 1272

Change the type of your connection in your Lookup Component :

In General tab -> Connection Type -> OLE DB connection manager

Upvotes: 0

Related Questions