This is our solution of the datawarehouse project.
- Visual Studio 2019
- SQL Server 2017
- SQL Server Integration Services Projects (extension)
- Open Visual Studio
- Click on "Extensions" in the menu bar
- Select "Manage Extensions"
- Search for "SQL Server Integration Projects
- Cannot create Database Diagram because insufficient permissions:
- Right click on the database
- Click on Properties
- Click on Files
- Type 'sa' in the owner field
- Fork the repository
- Add this repository as a remote called "upstream"
- Create a new branch
- Make your change
- Push your changes to your remote "origin"
- Go to this "upstream" repository on GitHub to create a pull request