O'Reilly logo

Pro SQL Server 2012 BI Solutions by Caryn Mason, Randal Root

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 8

image

Concluding the ETL Process with SSIS

Sometimes good things fall apart so better things can fall together.

—Marilyn Monroe

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required