Installing the sample solution

This section will walk you through the deployment of the databases contained in the sample solution.

Getting ready

This section assumes that you have downloaded the solution files.

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:

2. Now, we open the solution in Visual Studio by double-clicking on the SSISCookBook solution file, as highlighted in the preceding screenshot.
3. 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...