Concluding the ETL Process with SSIS
Sometimes good things fall apart so better things can fall together.
Thus far, the ETL process has taken us through a lot of decision making. Data has had to be cleaned up and handled with care to ensure it is accurate and that it can be worked with. In Chapter 7, we created an SSIS package and set up our data connections. We also configured and tested the Execute SQL tasks.
In this chapter, we continue the SSIS process by configuring data flows and data destinations that enable us to load our data warehouse, and we handle errors and round out this subject by executing the entire ...