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 7

image

Beginning the ETL Process with SSIS

I have this hope that there is a better way. Higher-level tools that actually let you see the structure of the software more clearly will be of tremendous value.

—Guido van Rossum

In the previous chapter, we discussed how to extract data from a source table and transform that data using SQL programming statements. This is a very traditional approach and works well for many professionals, particularly SQL programmers, but can feel cumbersome and tedious to work with.

To be successful with the SQL programming approach, you must thoroughly understand the code you are working with and visualize each action ...

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