One of my main gripes with Microsoft SSIS is that there is no way to reuse logic. In my data integration task I needed to do the same lookup and translation tasks (typically convert to upper case, replace " with 'N/A', look up column in side table and use the IDs from that table instead) many times, in my case when importing data from an Axapta database. CozyRoc got back to me and told me that they have released an SSIS component that includes new components for reusability of code and flows. Being a coder I had given up on SSIS and rewritten my work in C#/SQL, but next time I'm very much looking forward to using it.
In Scott Larsons blogpost referenced in my last post he gives a short but important note: his favourite MDX resource. And I agree: a 62 article series in learning MDX. Since I've worked with SQL "all my life" I've not bothered to much with MDX, but with this series I'm really looking forward to learning it better. To do the tutorials you'll need the free MS-SQL 2000 samples (that unfortunately aren't bundled with neither MS-SQL 2005 nor MS-SQL 2008). You can download them from here. I should note that while ...
At work I'm looking at PerformancePoint, and being a newbie with this product I of course do all the newbie errors. That's why I was so happy when finding Nick Barclay's blogpost where he explains all about the way-to-common connection errors. Big thank you to Nick.
Not quite happy with any of the programs I found to identify iTunes duplicates, I spent an hour making my own (beats tracking down duplicates. ) I thought I'd share it with you. It's my first attempt at using OS X' ScriptingBridge and written in Python. I have no clue if it runs out of the box, I suppose you should have Developer Tools installed. It's not the fastest beast either, and Python and iTunes both use 50% CPU. But it gets the job done. If you wonder why I give so many parameters to the track class I should say that I plan on reusing it to do some more iTunes housekeeping. The script will mark all the duplicates with one star. Then I can round them up and delete ...