Agile BI Community

I've been meaning to post this for a while, but real life keeps intruding. I did a presentation on SSIS performance for the Charlotte SQL Server User Group at the end of November. It went well, though I was trying to squeeze a 90 minute presentation into 60 minutes, so I had to skim over some of the good stuff. You can find the presentation here ...

I'll be doing a web cast for the Charlotte SQL Server User Group, our local PASS chapter, on SSIS Performance Tuning on Nov. 28, 2007 at 12:00 EST. From the abstract: ''This presentation will cover the various aspects of performance tuning in SQL Server Integration Services. We will start by covering some general best practices for performance. ...

A question came up recently on the SSIS forums on translating lookup codes into a description within the data flow. That is, given code ''A'', how do you translate it into a more descriptive value, such as ''Apple''? As a general rule of thumb, if the the codes and values might change over time, or if there are a significant amount of them, I ...