O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

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

C H A P T E R  8

Image

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 7, data maps are used as a basis for beginning ETL design. In our experience, a good deal of the initial work on a BI project consists of ETL process design, development, and debugging. We assume that you've completed your data map and created a simple package or two using the Import and Export Wizard or by using the SSIS package template in BIDS. In this chapter, we'll cover the following topics:

  • Considering ...

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