Export (0) Print
Expand All

Breaking Changes to Integration Services Features in SQL Server 2008 R2

This topic describes breaking changes in Integration Services. These changes might break applications, scripts, or functionalities that are based on earlier versions of SQL Server. You might encounter these issues when you upgrade. For more information, see Using Upgrade Advisor to Prepare for Upgrades.

NoteNote

For SQL Server 2008 R2, there have been no changes to the content that is listed in this topic.

The following table describes breaking changes between the version of Integration Services that is included with SQL Server 2008 and the version of Integration Services that is included in earlier releases.

Feature

Description

Provider names in connection strings

In SQL Server 2008, the names for the SQL Server Native Client provider and OLE DB Provider for Analysis Services have changed, and their connection strings use a different value. To automatically update connection strings that use these provider names, use the SSIS Package Upgrade Wizard to upgrade SQL Server 2005 packages. You can also update these connection strings automatically or manually in BI Development Studio.

Third-party and custom components

In SQL Server 2008, Integration Services has changed its application programming interfaces (APIs). To be compatible with these new APIs, all third-party and custom components must be recompiled.

Community Additions

ADD
Show:
© 2014 Microsoft