Share via

Scale up to a team can join to create a project SSIS and SSAS.

An Vd 0 Reputation points
2023-10-03T10:03:18.1033333+00:00

We have 2 servers, one is an APP server, the other is a DB server that shares the same domain. In the APP server, there is 1 SSIS project for ETL and 1 SSAS project for model building and analysis. But at a time only one person can access the server app to create SSIS data flow and analysis on SSAS. We want to scale it up so that a team can work at the same time. Is there any way to create SSIS data flow and analytic on PC and deploy to server but don't have to join domain and open connection from PC to all data sources (just open connect to APP and DB servers)? And how to merge SSIS and SSAS project from all the members?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,005 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,479 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,253 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 42,286 Reputation points
    2023-10-04T05:15:33.8366667+00:00

    For me it's not clear, what the problem is and what you are looking for?

    It's more then quite common, that a team with several members work on one BI project.

    Create in Visual Studio/SSDT one solution and import all existsting projects; VS can handle SSIS/SSAS & DB projects in one solution.

    Set the solution under source control like SVN, DevOps, GitHub or similar and then: Go

  2. ZoeHui-MSFT 34,186 Reputation points
    2023-10-04T07:00:26.37+00:00

    Hi @An Vd,

    Do you mean like this?

    Branching and Merging Strategy in Git for SSIS Projects

    Regards，

    Zoe Hui

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