Dynamic lookup cache not updating
The Lookup transformation is used to look up a source, source qualifier, or target to get the relevant data.You can look up the flat file and relational tables.The Integration Service inserts the row in the cache if it is new.– Applies to dynamic lookup cache only.The Integration Service inserts the row in the cache if the row type entering the Lookup transformation is insert and it is new.If the transformation uses a dynamic cache, the Integration Service inserts the row into the cache when it does not find the row in the cache.When the Integration Service finds the row in the cache, it updates the row in the cache or leaves it unchanged. The Integration Service passes return values from the query to the next transformation.NET or classic ASP, or other dynamic pages) in memory.This can yield enormous performance improvements, since the script used to generate the dynamic output does not need to run for each request.
The Integration Service updates the row in the cache if the row type entering the Lookup transformation is update, the row exists in the index cache, and the cache data is different than the existing row.
IIS also detects changes to the files when you make updates, and IIS flushes the cache as needed.
The IIS output caching feature targets semi-dynamic content.
If the row exists in the index cache but the data cache is different than the current row, the Integration Service updates the row in the data cache.– Applies to dynamic lookup cache only.
An expression that indicates whether to update the dynamic cache.