Discontinued Integration Services Functionality in SQL Server 2008 R2
This topic describes Integration Services features that are no longer available in SQL Server 2008.
Notes
For SQL Server 2008 R2, there have been no changes to the content that is listed in this topic.
Microsoft Visual Studio for Applications (VSA)
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.