CHAPTER 7
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 ...
Get Pro SQL Server 2012 BI Solutions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
