The first thing that must be done is setting up an SSIS solution. For simplicity, we'll use Microsoft wide world importers, just like we did in the previous chapter. The samples can be found at https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0.

From the list, we'll download the databases and SSIS solution:

• Daily.ETL.ispac: This is the SSIS solution that takes data from WideWorldImporters to the WideWorldImportersDW database
• WideWorldImporters-Full.bacpac: This is the transactional database that is used as a source for the data warehouse
• WideWorldImportersDW-Full.bacpac: This is the sample data warehouse database that we'll use in this chapter, and beyond