Comparing The SSIS 2008 Script Task to the SSIS 2005 Script Task
A couple differences leap out from the screen shots:
- The General and Script pages have changed position in the Page List - Script now comes up first. It now takes one less click to get to the actual script window. Good job SSIS Team!
- The SSIS 2008 uses VSTA instead of the VSA scripting engine. This means you can now write scripts in C#.
The SSIS 2005 Script Task:

The SSIS 2008 Script Task:

I have not stressed this task yet, but that is in the plans. I anticipate performance improvements across the board!
:{> Andy
Technorati Tags: Katmai SQL Server 2008 Script Task C#