Important Note about Upgrading to SSIS 2012

Posted on by — No Comments ↓

This post has been republished via RSS; it originally appeared at: SQL Server Integration Services (SSIS) articles.

First published on MSDN on Sep 20, 2012

When you upgrade to SQL Server 2012 Integration Services (SSIS) on a machine that has SSIS 2005 or 2008 installed, SSIS 2012 is installed side-by-side with the earlier version. Unlike upgrades to previous versions, the upgrade process does NOT remove the SSIS 2005 or 2008 files, service, and tools.


In addition, with this side-by-side install, multiple versions of dtexec utility are installed. To ensure that you run the correct version of the utility, at the command prompt run the utility by entering the full path ( <drive> :\Program Files\Microsoft SQL Server\<version>\DTS\Binn).


For more information about upgrading to 2012 SSIS, see Upgrade Integration Services and 5 Tips for a Smooth SSIS Upgrade to SQL Server 2012 .

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.