Discontinued Integration Services Functionality in SQL Server 2012

This topic describes Integration Services features that are no longer available in the current release of SQL Server Integration Services.

The options for connecting shapes on the design surface of the Control Flow tab and Data Flow tab have been discontinued in this release.

Data Source Views have been discontinued in this release.

The options to configure a data viewer to display data in a histogram, scatter plot, or column chart have been discounted in this release.

Support for migrating or running Data Transformation Services (DTS) packages has been discontinued in this release. The following DTS functionality has been discontinued.

  • DTS runtime

  • Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask namespace

  • Package Migration Wizard for migrating DTS packages to the next version of Integration Services

  • Support for DTS package maintenance in SQL Server Management Studio

  • Execute DTS 2000 Package task

  • Upgrade Advisor scan of DTS packages.

The Execute DTS 2000 Package task has been discontinued.

The ActiveX Script task has been discontinued, including the Microsoft.SqlServer.Dts.Tasks.ActiveXScriptTask namespace. You can re-create the functionality of your ActiveX scripts by using the new control flow containers and the more flexible precedence constraints available in Integration Services. Or, you can rewrite your scripts by using the Integration Services Script task.