How to upgrade SQL Server 2008 R2 SSIS package to SQL server 2016?

1
votes

We have few SSIS packages developed using VS 2008 R2 business development studio. WE need to upgrade them to SQL Server 2016. But I don't see a download for SQL Server 2016 business development studio. The only SQL Server Data tools available are for 2017(Preview) & 2015. Please let me know, how to upgrade these packages?

https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt

Thanks in advance.

Edit: I tried to open with VS2015. I do have SSDT installed as per this screenshot. enter image description here

1
sql-serverssissql-server-2008-r2sql-server-2016
SQL Server Data tools available are for 2017(Preview) & 2015 => It is Visual Studio versions not SQL Server version, download 2015, open project in Visual Studio and deploy - Lukasz Szozda
I already have Visual Studio 2015. Do you mean download SQL Server data tools for 2015? - WinFXGuy
Exactly. Download, install and run - Lukasz Szozda
Thank you. Can I deploy the packages to SQL Server 2016 when I open in 2015 version of BDS? - WinFXGuy
Yes, it should work. Please forgot the Business Developemnt Studio name, nowadays there is Visual Studio + SSDT. - Lukasz Szozda

1 Answers

1
votes

According to this Microsoft article, these are the related visual studio versions related to SQL Server :

==================================================================================================================================================
|| SQL Server version  ||   Development environment for SSIS packages                                                                           ||
==================================================================================================================================================
|| 2016                ||  SQL Server Data Tools for Visual Studio 2015                                                                         ||
|| 2014                ||  SQL Server Data Tools for Visual Studio 2015 or SQL Server Data Tools - Business Intelligence for Visual Studio 2013 ||
|| 2012                ||  SQL Server Data Tools for Visual Studio 2015 or SQL Server Data Tools - Business Intelligence for Visual Studio 2012 ||
|| 2008                ||  Business Intelligence Development Studio from SQL Server 2008                                                        ||
|| 2005                ||  Business Intelligence Development Studio from SQL Server 2005                                                        ||
==================================================================================================================================================

To upgrade package, all you need is to download SQL Server data tools 2015, and open the package with it. It will upgrade it automatically

Related Articles: