BI Thoughts and Theories

BIDSHelper 1.2 is now available at CodePlex . The new version has a number of SSIS specific features, like expression and configuration highlighting, a tool window that lists all the expressions in the package, and a Package Smart Diff tool. Darren (one Read More...

Jamie posted a question on ragged hierarchies to his blog today: Are you balanced or unbalanced? I started thinking about it this evening, and decided to post my thoughts here. I think that, for the most part, business requirements drive should drive Read More...

The 0.9 beta of BIDS Helper has been released on CodePlex. It's got a lot of great features for working with Analysis Services, and some future enhancements will include SSIS. Read More...

I was recently asked to help someone retrieve information from Active Directory for use in SSIS. My initial thought was "This shouldn't be too difficult. I know there is an OLE DB driver for Active Directory, so it should just be a matter of hooking up Read More...

I was on the CodePlex ( www.codeplex.com ) site today looking for the Analysis Services Stored Procedure project, and found that they have a number of SQL Server related projects available. First, all of the SQL Server samples have been uploaded to the Read More...