Share via

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.

Control Flow and Data Flow Auto Connect

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

Data Source Views have been discontinued in this release.

Data Viewer

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

Data Transformation Services (DTS)

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.

Execute DTS 2000 Package Task

The Execute DTS 2000 Package task has been discontinued.

ActiveX Script Task

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.

See Also


Deprecated SQL Server Features in SQL Server 2012