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.
