posted on Friday, June 08, 2007 1:01 AM by andy

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#

Comments