Blog

Upgrading to SQL Server 2014 In SSIS

  • (4.0)
  •   |   348 Ratings

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.

Learn how to use SSIS, from beginner basics to advanced techniques, with online video tutorials taught by industry experts. Enroll for Free SSIS Training Demo!

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.

List of Related Microsoft Certification Courses:

 SSRS  Power BI
 SSAS  SQL Server
 SCCM  SQL Server DBA
 SharePoint  BizTalk Server
 Team Foundation Server  BizTalk Server Administrator

 


Popular Courses in 2018

Get Updates on Tech posts, Interview & Certification questions and training schedules