VSTA support for Script Task and Script Component in SSIS ( SQL Server Integration Services ) 2008
VSTA support for Script Task and Script Component in SSIS 2008
Unlike SQL Server 2005, SQL Server 2008 provides VSTA (Visual Studio Tools for Applications) environment for writing Script Task and Script Component instead of VSA (Visual Studio for Applications) environment. VSTA includes all the standard features of the Visual Studio environment, such as the color-coded Visual Studio editor, IntelliSense, and Object Browser and debugging features like breakpoints, watch/auto/locals windows and many more.
Refer this link to learn more details about it.