Software Needed to create SSIS packages and SSRS Reports

If I install Visual Studio 2019 (SSDT), will that alone enable me to create SSIS Solutions and RS reports?

(I will have the SQL 2019 Developer Edition installed)

Is anything else needed? Thanks

I don't think there is a standalone version of SSDT for Visual Studio 2019. You have to install VS 2019 and then add the SSDT components.

And yes - once you have that installed then you can created SSIS and SSRS solutions. Just remember that you also need to set the project deployment to the version you are deploying - for example, if deploying to a 2017 instance you would change the project to that version.

1 Like

Thanks very much, jeffw.