Deprecated Features in SQL Server 2005 Integration Services
New: 14 April 2006
This topic describes the SQL Server 2005 Integration Services features that are scheduled to be removed in future releases of the product. The following features are still available in SQL Server 2005.
SQL Server 2000 Data Transformation Services (DTS) Object Model
The SQL Server 2000 Data Transformation Services (DTS) object model is deprecated. You should plan to remove dependencies on this object model in anticipation of the next release of SQL Server. The SQL Server 2000 DTS object model itself will continue to be supported in SQL Server 2000 and SQL Server 2005 as part of our ongoing commitment to provide support for those versions of SQL Server; however, the ability to migrate SQL Server 2000 packages may not be supported in the next release.
The DTS functionality that will be deprecated includes the DTS API, the Package Migration Wizard for migrating DTS packages to the next version of SQL Server, support for DTS package maintenance in SQL Server Management Studio, and the Execute DTS 2000 Package task.
ActiveX Script Task
The ActiveX Script task in SQL Server 2005 Integration Services (SSIS) is provided only for backward compatibility with DTS and will be removed in the next version of SQL Server. Do not use this feature in the development of new packages. You should modify packages that currently use this feature as soon as possible. You may be able to recreate the functionality of your ActiveX scripts by using the new components and the more flexible precedence constraints available in Integration Services. Or, you can rewrite your scripts by using the Integration Services Script task.
Microsoft Visual Studio for Applications (VSA)
In future versions of Integration Services, Visual Studio for Applications (VSA) will be replaced with Visual Studio Tools for Applications (VSTA) as the engine in the Script task and Script transformation. While this change is not anticipated to incur a dramatic departure from existing syntax, this change may require script conversions when migrating to the next version of Integration Services.
In the next version of Integration Services:
- Microsoft will support the conversion to VSTA of existing Script task and Script transformation scripts authored in VSA.
- Microsoft will support execution of existing non-compiled VSA scripts.
In future versions of Integration Services:
- Microsoft will support the conversion to VSTA of existing Script task and Script transformation scripts authored in VSA
- Microsoft will not support execution of VSA scripts.
17 July 2006