question

HSBEmployee-1211 avatar image
0 Votes"
HSBEmployee-1211 asked ·

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

Is is possible to migrate SSIS packages created in Visual studio 2008 to Visual studio 2019? I followed instructions from this link (https://docs.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-supported
ssis-error.jpg (117.0 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DSPatrick avatar image
0 Votes"
DSPatrick answered ·

You can download SSDT for VS 2019 here

https://docs.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.





·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HSBEmployee-1211 avatar image
0 Votes"
HSBEmployee-1211 answered ·

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

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Sounds good, you're welcome.


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






0 Votes 0 ·