Is It Possible to migrate SSIS Packages from Visual Studio 2008 to Visual Studio 2019

Question

Is is possible to migrate SSIS packages created in Visual studio 2008 to Visual studio 2019? I followed instructions from this link (https://learn.microsoft.com/en-us/sql/integration-services/install-windows/upgrade-integration-services-packages-using-the-ssis-package-upgrade-wizard?view=sql-server-ver15) to begin the migration process, from within the SQL Server Management Studio (v 18.5) and got the error displayed in the attached screen print. The SSIS services running are version 13.0. And from what I can tell, the issue is related to the difference between the version of SSMS and the SSIS services. Ultimately, I'd like to know if it's even possible to migrate packages created in VS 2008 to VS 2019, and if so, how? How can I work around the error I'm getting? Or is this simply a case were we'll have to rebuild the packages from the ground up in VS 2019 to run with the new services.

Also, I noticed that within VS 2019, there was an option to connect to SSIS Integration Services in Azure. Would migration be easier via the Azure connection? Is there documentation on how to facilitate such a migration via the Azure connection is SSMS 2019?

Thanks!

Answer 1

You can download SSDT for VS 2019 here

https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15

Visual studio is not currently supported here on QnA. They're actively answering question in dedicated forums here.

https://developercommunity.visualstudio.com/spaces/8/index.html

https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=visualstudiogeneral

and possibly over here.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlintegrationservices

--please don't forget to Accept as answer if the reply is helpful--

--------------------------

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

Answer 2

Thanks Dave! I'll post this in one of the other forums.