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

HSB Employee 1 Reputation point
2020-06-18T18:45:29.4+00:00

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!

10363-ssis-error.jpg

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,199 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dave Patrick 426.1K Reputation points MVP
    2020-06-18T18:53:08.503+00:00

    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.

    0 comments
  2. HSB Employee 1 Reputation point
    2020-06-18T19:30:02.69+00:00

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