Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Archive for November 2008

Variation on the theme of cache-warming in SSIS

leave a comment »

Over on SQLIS.com, Allan Mitchell shows a variation on my original approach on how to build a cache-warmer in Integration Services:
http://www.sqlis.com/post/SSAS-Cache-Warming-Using-SSIS.aspx

The key difference is the Trace File Source component that allows you to connect direct to a trace file rather than have to persist the trace information to a SQL Server table. The component hasn’t been released yet but it will be soon (Allan and Darren have been working on it for a while); I’m going to try to use it in my PASS Presentation in two weeks. Once it’s out I intend to update my cache-warmer package and make it available for download from Codeplex or somewhere similar. I’ve got a few more ideas on how to improve it and I think it’s something that a lot of people would find useful.

Written by Chris Webb

November 4, 2008 at 10:41 pm

Posted in Analysis Services

Follow

Get every new post delivered to your Inbox.

Join 3,083 other followers