Upgrading to SQL Server 2014
Recommended by 0 users
If you already built components in SQL Server 2008 and you want to use them in SQL Server 2014, you have to update the references and recompile the components. There weren’t any significant changes to SSIS from 2012, and all components compiled to run against 2012 will automatically work in 2014.
Microsoft has retained the same interface names used in SQL Server 2008 (for example, IDTSInput100) so the upgrade process is straightforward. To upgrade, simply open your old Visual Studio 2008 project in Visual Studio 2010, 2012 or 2013. The project will upgrade automatically to the new Visual Studio format. You then need to update the references to the latest SQL Server 2014 Integration Services components referenced in the beginning of the Programming and Extending SSIS Topic. Most of the code should be the same, as the interfaces haven’t changed that much between SQL Server 2008, 2012, and 2014 in reference to the SSIS interfaces. Everything should compile, and you should be able to run your components in the SQL Server 2014 SQL Server Data Tools environment.