Discontinued Integration Services Functionality in SQL Server 2008
This topic describes Integration Services features that are no longer available in SQL Server 2008.
In SQL Server 2008, Visual Studio Tools for Applications (VSTA) has replaced Visual Studio for Applications (VSA) as the scripting environment for the Script task and Script transformation. While this change does not require scripts to be rewritten, it does require that Script tasks and transformations that contain VSA scripts be upgraded when you migrate existing Integration Services packages to SQL Server 2008.
In SQL Server 2008, VSA scripts that are contained in Script tasks or transformations will be converted to VSTA before Integration Services runs the scripts.