Audit Dimensions in SQL/SSIS 2008

View previous topic View next topic Go down

Audit Dimensions in SQL/SSIS 2008

Post  DavidStein on Tue Nov 30, 2010 10:42 am

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?

DavidStein

Posts : 24
Join date : 2010-04-01

View user profile

Back to top Go down

Re: Audit Dimensions in SQL/SSIS 2008

Post  DavidStein on Thu Dec 02, 2010 12:39 pm

Bump. Nobody?

DavidStein

Posts : 24
Join date : 2010-04-01

View user profile

Back to top Go down

Re: Audit Dimensions in SQL/SSIS 2008

Post  Joy on Thu Dec 02, 2010 3:14 pm

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.
avatar
Joy

Posts : 20
Join date : 2009-02-03
Location : Kimball Group

View user profile http://www.kimballgroup.com

Back to top Go down

Re: Audit Dimensions in SQL/SSIS 2008

Post  DavidStein on Thu Dec 02, 2010 3:17 pm

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/

DavidStein

Posts : 24
Join date : 2010-04-01

View user profile

Back to top Go down

Me too! Me too!!! *waves arms impatiently*

Post  NbleSavage on Mon Dec 06, 2010 8:03 pm

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

Thanks Joy!


- Savage

NbleSavage

Posts : 24
Join date : 2010-11-28

View user profile

Back to top Go down

Any?

Post  NbleSavage on Wed Dec 08, 2010 8:26 pm

ttt for any news

NbleSavage

Posts : 24
Join date : 2010-11-28

View user profile

Back to top Go down

Re: Audit Dimensions in SQL/SSIS 2008

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum