Compiling SSAS, SSRS, and SSIS projects under Build Tools for Visual Studio 2022?

Zarate, Martin 5 Reputation points
2024-05-31T14:54:04.85+00:00

I have a build server using Build Tools for Visual Studio 2022 to compile projects. We have several systems that are currently not using the build server because they use SSAS, SSRS, and SSIS projects. Investigating, it looks like Build Tools does not support these in any way, since compiling them requires an extension installed into Visual Studio, and Build Tools does not support extensions.

Is there any good work-around for this problem? At this point I'm starting to hand-roll code to just copy the needed subdirectories from a full VS install into Build Tools, which is stupid and wrong but seems to be the only solution rather than dealing with the hassle of managing full VS installs on build servers.

The fact that there is no WinGet/Chocolatey-like idempotent tool for easily installing these extensions into a full Visual Studio install only makes the situation worse. VsixInstaller and Marketplace do like 90% of the job it's very disappointing they don't do the last 10%.

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.
2,854 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
189 questions
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
996 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 42,746 Reputation points
    2024-05-31T18:47:20.1833333+00:00

    currently not using the build server because they use SSAS, SSRS, and SSIS projects.

    What do you want to "compile" on SSAS/SSRS/SSIS projects?

    You make modifications on the project ... done, nothing to "compile".

    Or do you mean to deploy instead?

    0 comments
  2. ZoeHui-MSFT 34,756 Reputation points
    2024-06-03T05:54:26.9733333+00:00

    Hi @Zarate, Martin,

    Not really clear about your issue.

    SQL Server Data Tools (SSDT) is a set of development tooling for building SQL Server databases, Azure SQL databases, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy SQL objects with the same project concept as other application development tools. The SQL projects capability extends to CI/CD pipelines, enabling you to automate the build and deployment of your database projects with the SqlPackage CLI.

    In summary, SSIS is used for ETL, SSAS is used for data analysis and modeling, and SSRS is used for reporting. Together, these tools provide a complete data platform for extracting, transforming, analyzing, and reporting data

    Regards，

    Zoe Hui

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

    0 comments