Monthly Archives: October 2011

How to hide Calculated Members in MDX SSAS

Posted on October 29, 2011 by MikeDavisSQL

With some calculated members in MDX it only makes sense to see the calculation if a certain Hierarchy is used. For example: Aggregate(YTD([Date].[Calendar].CurrentMember),[Internet Sales Amount]) This calculation only works in the Date.Calendar Hierarchy. I wanted to show the end users … Continue reading →

Posted in mdx, SSAS, Syndication | Tagged , | 4 Comments

Setting up SSIS Auditing Part 2

Posted on October 21, 2011 by MikeDavisSQL

Auditing in SSIS can be a real headache. In this two part series blog I am going to try to make it a little easier. You can also download my white paper and sample files on Auditing SSIS here. You … Continue reading →

Posted in SSIS, Syndication | Tagged | Leave a comment

SQL PASS Summit 2011 The Aftermath

Posted on October 18, 2011 by MikeDavisSQL

I just returned from Seattle, WA and my first time speaking at SQL PASS Summit. I did the SQL Smackdown T-SQL vs SSIS Loading a Data Warehouse with Adam Jorgensen. The session was a hit, it was standing room only … Continue reading →

Posted in PASS, SSIS | Tagged , , , | Leave a comment

Setting up SSIS Auditing Part 1

Posted on October 17, 2011 by MikeDavisSQL

Auditing in SSIS can be a real headache. In this two part series blog I am going to try to make it a little easier. You can also download my white paper and sample files on Auditing SSIS here. You … Continue reading →

Posted in SSIS, Syndication | Tagged | 1 Comment

Using Configuration Tables in SSIS 2008/2005

Posted on October 4, 2011 by MikeDavisSQL

SSIS packages are great ETL tools and can do just about anything you need in terms of ETL. Most organizations start out creating SSIS package one by one until they have dozens, hundreds, or even thousands of packages. I have … Continue reading →

Posted in SSIS, Syndication | Tagged , , | Leave a comment