SSIS Visual Studio 2019 for SQL Server 2008

Question

The question is can I use Visual Studio 2019 with the most current SSIS to create SSIS packages for SQL Server 2008? Or do I need to download an earlier version of Visual Studio?

I do not have access yet to execute on the server I am waiting for this and just doing some research to get tools ready in the mean time. So I have not tried anything yet.

question from:https://stackoverflow.com/questions/65861688/ssis-visual-studio-2019-for-sql-server-2008

Answer 1

You have to install SQL Server Data Tools (SSDT) for Visual Studio 2019.

This is the link

https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?redirectedfrom=MSDN&view=sql-server-ver15

Says that you can't.

Supported SQL versions

Integration Services packages SQL Server 2012 - SQL Server 2019