Monthly Archives: April 2008

Renaming the Script Project in SSIS 2008

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 … Continue reading

Posted in Uncategorized | Comments Off

MDX Filters in PPS Monitor

I had a question on how to implement MDX Filters in PerformancePoint Monitor awhile back.  Nick Barclay  provided an answer here. Some samples Nick provided were: 1: [Time].[Fiscal Year].Children and 1: DESCENDANTS( 2: [Geography].[Geography].[All Geographies] 3: ,[Geography].[Geography].[Country] 4: ,SELF_AND_BEFORE) Depending … Continue reading

Posted in Uncategorized | Tagged , , | Comments Off

David Darden’s Blog

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 … Continue reading

Posted in Uncategorized | Comments Off

Creating a Scorecard Transform in PerformancePoint Server Monitor

Overview I’ve spent a couple of days doing some prototyping around PerformancePoint Monitor… there have been a few things that I’ve wanted to accomplish, so when the PerformancePoint Monitoring SDK was released, it seemed like the way to do it.  … Continue reading

Posted in Uncategorized | Comments Off

Common Expressions In the Data Flow

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 … Continue reading

Posted in Uncategorized | Comments Off

Sending an Alert if a Package Runs Too Long

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 … Continue reading

Posted in Uncategorized | Comments Off