Variation on the theme of cache-warming in SSIS

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s