BI Thoughts and Theories

I found something interesting in SSIS 2008 today, and thought I'd share it. I was working with David Darden on a package that included a script task. In 2008, the Visual Studio Tools for Applications (VSTA) environment is used to edit script tasks. It Read More...

One of my colleagues, David Darden , has started blogging on www.agilebi.com . He's been working with the Microsoft BI stack for several years now, and has a lot of great knowledge to share. His first post is on using the PerformancePoint SDK to create Read More...

I use the Derived Column transform in the Data Flow a lot. In fact, I can't remember the last time I wrote a production package that didn't include at least one Derived Column transform in it. Over time, I've built up a lot of common expressions that Read More...

A question that has come up in a few different situations recently is how to send someone an alert if your package is taking too long to execute. For example, you might have a package that loads a large number rows from a source system to a destination Read More...