Lookup and Cache Transforms refresh option??

• sandyinfowave

  Default port

  Points: 1490

  More actions

  December 9, 2011 at 10:17 am

  #391090

  Do we have an option to refresh the cache in Cache transforms??? How does the Cache transforms actually work??(because the data keeps on changing)

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  December 12, 2011 at 2:16 am

  #1419898

  You need to run the package that contains the Cache Transform to refresh the cache.

  http://blogs.msdn.com/b/mattm/archive/2008/11/22/lookup-using-the-cache-connection-manager.aspx

  Make sure you also read the references at the bottom of the article.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP