Chapter 8. Intermediate SSIS

By now, you've translated your business requirements into an SSAS cube. The next task in implementing your BI project is to execute an ETL solution from your detailed data map.

As discussed in Chapter 3, data maps are used as a basis for beginning ETL design. In my experience, up to 75% of the initial work on a BI project consists of ETL process design, development, and debugging. I assume that you've completed your data map and created a simple package or two using the Import/Export Wizard or by using the SSIS package template in BIDS. In this chapter, we'll cover the following topics:

  • Considering general ETL package-design best practices

  • Understanding control flow tasks

  • Understanding data flow transformations

  • Using the ...

Get Foundations of SQL Server 2005 Business Intelligence now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.