Beginning the ETL Process with SSIS

Abstract

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.

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