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