Share via

Install only SSIS and SSRS development projects in VS 2019

Anne 281 Reputation points
2020-11-19T20:36:14.853+00:00

I need to install VS studio community version 2019 for SSIS and SSRS projects.
I only use VS for SSIS, and SSRS, not for other development.
My question is when I do the install of VS, do I need to install any workload? do I need to install at least Asp.net development workload, or I don't need to install any workload, but just go to extension and install SSIS project or SSRS project?

Thanks,

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 41,491 Reputation points
    2020-11-20T01:40:12.013+00:00

    Hi @Anne ,

    Here is a blog for you to install SSIS and SSRS with VS2019.

    https://tomaztsql.wordpress.com/2019/11/03/installing-ssis-ssrs-and-ssas-with-visual-studio-2019/

    If you just want to use SSRS and SSIS without any develop requirement, you don't need to install Asp.net.

    Regards，
    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    What can I do if my transaction log is full?--- Hot issues November

    How to convert Profiler trace into a SQL Server table -- Hot issues November

    0 comments

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. David Browne - msft 3,851 Reputation points
    2020-11-19T23:50:58.61+00:00

    SQL Server Data Tools is a pre-requisite for the SSIS, SSRS, and SSAS add-ins. If you don't install it initially, it will be installed when you install the add-ins.

    1 person found this answer helpful.
    0 comments
  2. Anne 281 Reputation points
    2020-11-19T22:36:02.287+00:00

    Thank you.
    It is still not clear to answer my question.
    I don't need the data tool, I only need to install SSIS and SSRS.
    But before install them I need to install VS community, during the install process, do I need to choose at least the one of the workload for example the asp.net web , or I don't need to?
    But just intall the extension of SSIS and SSRS?

    Thanks

    0 comments
  3. Anne 281 Reputation points
    2020-11-19T22:43:26.09+00:00

    Ok, thanks that is an option.

    I thought I don't even need SSDT. Note this SSDT is not for SSRS and SSIS. It is SQL server database project. Although the name is the same as SSDT BI tool, that is before SQL server 2016.

    0 comments
  4. Anne 281 Reputation points
    2020-11-19T22:53:58.673+00:00

    I am not using old, I am using SQL server 2019 and SSIS, SSRS 2019.

    So I guess I don't need to install asp.net web development workload, but just SSDT , and then SSRS and SSIS extension.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.