Audit Dimensions in SQL/SSIS 2008

I've read The Micorosoft Data Warehouse Toolkit and would like to implement the audit dimension and logging set up described in that book. However, I believe the download from the book's site is for SSIS 2005. Has anyone published an updated framework for 2008 or have another quality model I can use as basis for my DW implementation?

Bump. Nobody?

Yikes! The 2008 SSIS packages used to be up on the book's website, but I don't see them there now. I'll get them up there and post here when they're available. Expect them in a day or two. Sorry about that.

The 2008 version of the packages don't match the originals. Instead, they implement better practices. The audit dimension is one place they differ... the new version (which I can hardly call "new" any more) is even simpler than the version described in the 2005 book. My goal for the design of this audit dimension is to set the bar so low that you can have no excuse to not implement some sort of auditing.

That's great Joy, I really appreciate it. Any idea what kind of timeframe I might expect? Also, I really enjoyed meeting both you and Warren at the PASS Summit.

In case you're wondering which person I was at the conference, you can see pics of me here:

http://www.made2mentor.com/2010/11/pass-vacation/

I'd love to know when the 2K8 SSIS packages are once again available.

Thanks Joy!


- Savage

ttt for any news