How to do it...

1. We'll first create a folder that will hold the solution files. In our case, we created a folder called C:\Projects\SSISCookbook and we uncompressed the solution file in it, as shown in the following screenshot:

1. Now, we open the solution in Visual Studio by double-clicking on the SSISCookBook solution file, as highlighted in the preceding screenshot.
2. The solution opens and you will see its projects, as shown in the following screenshot:

The following point will describe the projects that are shown in the Solution Explorer in SQL Server Data Tools (Visual Studio):

• DB.AdventureWorksLT: This is an SQL Server database project that contains the AdventureWorksLT database objects.
• DB.AdventureWorksLTDW: This is the SQL Server database project that contains the staging, DW, the framework database objects. We'll talk about the framework in a subsequent recipe.
• ETL.DW: This is an SSIS project that fills the tables in the DW schema.
• ETL.MasterData: This is an SSIS project that connects to Master Data Services and loads the DW.DimOrderProvenance table in the AdventureWorksDW database.
• ETL.Staging: This is an SSIS project that loads the tables in the staging schema in the AdventureWorksDW database.