Excerpt from chapter 3, SSIS Tasks of the Wrox book Professional Microsoft SQL Server 2008 Integration Services
By Brian Knight, Erik Veerman, Grant Dickinson, Douglas Hinson, Darren Herbold
The Script Task allows you to access the Microsoft Visual Studio Tools for Applications (VSTA) environment to write and execute scripts using the VB and C# languages. The VSTA environment is new in the latest version of SSIS and replaces the Visual Studio for Applications (VSA) environment from the 2005 version. Scripting now is almost a misnomer because the latest SSIS edition solidifies the connection to the full .NET libraries for both VB and C#. The latest addition to SSIS of the VSTA environment and the Script Task in general also offer these extra functional advantages: