This was part of the solution to the project my team was working on (that I'm still in the process of writing up), but I thought I'd post it separately because it has various uses. The Problem We have a package which does some aggregations based on a...

As I previously mentioned , the current Katmai CTP contains a pretty major reworking of how data flow tasks get executed. Michael Entin has written up an overview of the changes that should be of interest to any long time SSIS users.

The provider name for SQL Native Client (SNAC) connections has changed in Katmai. Since this is the default provider for OLEDB connections, you'll probably be affected by this change if you're running SQL Server 2005 packages in Katmai. Version Provider...

A nice convenience feature in the new VSTA based script task is that we now provide a variable selection dialog for the ReadOnlyVariables and ReadWriteVariables properties. Ok, so there's not much content in this post. I admit it - this was just a reason...

[ Edit: Note, this has been resolve in current Katmai CTPs ] You may run into issues in the current Katmai CTP if your script task uses objects contained within the ManagedDTS assembly. If you're interested in the details, keep reading - otherwise...

(Note, when I use the word "components" in this post, I'm referring to all extensible items, including tasks, pipeline components, foreach enumerators, loggers and connections) The first major change I worked on as part of the SSIS team was re-versioning...

The first public community technology preview for SQL Server 2008 (code named Katmai) was announced at TechEd yesterday, and is now available for download. You can register here to download the developer editions, and post questions / comments / concerns...

May has been a busy month! The first Microsoft Business Intelligence conference was earlier in the month, and it seemed to be a big success. I was amazed at how many people were there, and I met a lot of interesting people when I was manning the demo...