July 15, 2011 at 9:25 am
I have a Data Flow Task that caches dimension tables using the cache connection manager and the next DFT uses the cached tables to perform a lookup to retrieve the dimension keys.
Is there a task or a execute sql command that can explicitly clear the cache before the package is run to make sure the cached connection manager retrieves the most recently updated dimension table?
The issue I am having is that the lookup is still using the cached table from the previous runs and the cache is not being populated with the newly update table.
Any help will be appreciated!
Thank you!
Jay
December 21, 2011 at 4:05 pm
The cache connection transform should build from scratch every run.
December 22, 2011 at 2:45 am
If you really want to be sure, you can delete the .caw file every time.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply