This section will walk you through the deployment of the databases contained in the sample solution.
- 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:
- Now, we open the solution in Visual Studio by double-clicking on the
SSISCookBook
solution file, as highlighted in the preceding screenshot. - 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 theAdventureWorksLT
database objects.DB.AdventureWorksLTDW
: This is the SQL Server database project that contains the staging, DW, the...