March 2009 Entries

Debugging SSIS ScriptTasks and ScriptComponents with Information Messages
I recently had to do some simple debugging of some script tasks and components in SSIS and through I would share the simple technique that I was using. While this is only just above the level of debugging using MessageBoxes it can still be quite handy. It basically consists of printing information messages to the Progress/Execution Results window in BIDS. The syntax differs between the ScriptTask and the ScriptComponent and I keep forgetting it, so I figured if I posted it here I should be able to ......

Posted On Sunday, March 29, 2009 8:28 PM | Comments (7)

OT: OfficeLabs Search Commands for Office 2007
I quite like the new ribbon interface in Office 2007, but occasionally I still find myself sometimes hunting for commands that I know exist somewhere..... If you are the same, then you will be pleased to know that there is a really good solution to this situation in the form of the Search Commands plugin from the OfficeLabs team at Microsoft. It adds a tab to the ribbon that lets you search all the commands in any of the office applications. If for instance you could not find the Spell Check facility ......

Posted On Wednesday, March 18, 2009 10:41 PM | Comments (0)

SSAS: There is no such thing as an Attribute in MDX!
In MDX in SSAS the term "attribute" occasionally gets used interchangeably with "hierarchy" and "level", but it's not technically accurate. In SSAS, MDX has concepts of Dimensions, Hierarchies and Levels, but not Attributes. Attributes and Attribute Relationships are design time concepts that are understood by the storage engine, but they are not directly exposed in the MDX language. Attributes actually map to levels (or properties) in MDX. I think the confusion comes about because, by default, an ......

Posted On Sunday, March 15, 2009 11:04 PM | Comments (3)