Variation on the theme of cache-warming in SSIS

Over on, Allan Mitchell shows a variation on my original approach on how to build a cache-warmer in Integration Services:

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: Logo

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: